monthly

I need to create a loan amortization schedule using Access. My challenge comes as we are using compound interest and I need to determine the monthly payments. I am able to get the total to be repaid using the formula: =[LoanAmount]*((1+[InterestRate]/[CompoundType)^([LoanTerm]*CompoundType))...

I have done something wrong, but don't see it: One year of 59.49 monthly investments Rate = 8.2% annual (cell AZ15) nper = 12 months pmt = 59.49 each month (cell BD38) pv = 0 Answer should be 1,142.43 Using the formula: =FV(AZ15/12,1*12,-BD38,,0) returns 741.33 What did I do wrong?? I...

Hi, I'm not sure if it's possible, but this is what I'm trying to achieve. I have a sheet with around 40 columns. Each column has a heading (name of a different company). Going down the first column are the following labels (Gas: Unit Price, Cost Monthly, Quarterly, Annually). This is repeated...

Using Excel 2010 and Windows 10 s1803 Hi I’ve got a workbook with tabs: Summary / Jan / Feb / … / Dec The Summary picks up the various row totals in each of the Month’s sheets I will (potentially) need extra rows in each of the Monthly sheets so I have already set up, with formulae...

I want to be able to automatically enter the value of monthly construction costs following an s curve spend profile. I want the ability to simply enter the contract value and monthly term to create a spend profile that follows the s curve principle. Anybody cracked this?

Hi All, I have had a look at a number of forums to try and find the answer to my question, but I will need this to be simplified. Suppose I started paying £20 every month into an investment portfolio for the next 40 years, with a fixed interest rate of 2.5%. However, every year I increase my...

Hi there, got an issue with an index match formula im trying to do. I want to say if the value in cell K10 (report tab) is equal to either a15:b15 or a28:b28 (merged cells in monthly tab). then i want to return the value between d15:au15 or d28:au28 (both monthly tab) respectively IF the...

Hello All, I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount. For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission...

Hi Guys I have a question regarding lookups. I am using this code to do an index and match. the Mon_qu_sa_A are named cells / ranges. The code essentially works as intended with one exception the variable intPmtFreq in the formula once vba is ran says just monthly and so the cell shows #NAME...

I never use Excel to create graphs/charts. I was asked to do one today and I'm having an issue. the data is weekly but the horizontal access should be monthly. It's showing the weeks which of course makes it look terrible. In fact the dates don't line up with the data. Help!

So I have this spreadsheet that polled people as to what activities they would like to do. How do I make a pie chart about that shows the percentages of those who said "yes" to each individual thing? <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col...

Hi, Im a little rusty with VB, as I haven't used in quite sometime, so please bear with me! im trying to open a file and using the below code: 'Opening Monthly Summary Report MsgBox "Please Open Monthly Summary Report", vbOKOnly, "Monthly Summary Report" H =...

I have a few spreadsheets with monthly payment. but the start date and end date falls in certain days of the month, so i would like to have the exact daily payment instead of the monthly payment since the Dates include more than half of the month: Here is a list of spread sheet <tbody>...

Is it possible to obtain a timeline slicer value in a cell ? or even better yet to use in a Footer ? I am only using slicer on a Monthly purpose and would like to format to see as January - 2018 Thanks

Hi I want to use don't chat for these values monthly expense = 500 monthly income = 1200 balance = 700 Which values should go to doughnut chart? I want to do it like progressing chart. whenever the expense reaching the income the chart move further etc Thank you so much.

I thought this would be fairly simple, but I am struggling. I have 12 monthly worksheets with various headings such as Total, Purchases, Motor etc. Beneath those headings are daily entries and these are totalled at the bottom. All I want to do is copy the totals from each month to a new sheet...

Not sure if this can be done or explain but will try. All employees get a workbook that has about 12 worksheets. I need to try and combine one worksheet from everyone workbook for a monthly report. There are many formulas in these worksheets. Not sure if possible but thought I would ask...

As per title, can anyone teach me how to formulating the "SUMIFS" for different product qty in monthly basis? I used below formula to obtain the monthly "In" & "Out" qty of each items, but it seems not working perfectly. =SUMIFS('Daily Inventory Record-FE01'!$D$6:D66900,'Daily Inventory...

Good morning, everyone. I have a pivot table that I would like to add some conditional formatting to and I am not sure how to accomplish this. I have monthly sales average for System 1 and System 2. If there is an increase with System 2 compared to System 1, I would like to show cell filled in...

<tbody> A B D E Reference 1 Monthly Sales Rebate Target Rebate Target 2 1245000 1500000 500000 3 1000000 4 1500000 5 2000000 </tbody> Dear Members Greetings from Nigeria. First of all Thank you for having this Forum. This really helps me learn a lot. Please look...