Advanced Forumulas - Assistance on various Advanced Formulas

[UNNRE4LL]

Hello,

I have about 5 or 6 advanced formula questions I'm stumped on. I'm trying to sharpen my Microsoft skills. I have put together a word document. It contains various advanced formula questions, about 5 in total. Could anyone take a look and see what am I doing wrong?

https://us2-broadcast.officeapps.li...cfe_c0cd25ea-b39b-4d0a-bb6d-5ab1c5df6a55.docx

Thanks,

Mike

 

[easy2understandexcel]

Mike, can you paste the question here and more people might be willing to respond. Also, if they are unrelated if you put them in separate posts with good descriptions it might also further improve your response.

 

[FDibbins]

Hi, welcome to the board

Many members - myself included - are unable (or unwilling) to go to file-hosting sites. As suggested, post your questions here, where members can see them directly, instead of needing to follow some link to see what you want

 

[UNNRE4LL]

Sorry, I was broadcasting the word DOC as an online presentation since it contained the screenshot of the spreadsheet.

Here are the questions.

1. Create a formula in the selected cell that will return the future value of savings that will result using the data in column C.
Here are the formulas I've tried.

=FV(RATE,NPER,PMT)
=FV(C7/12,C10,C6)
=FV(ANNUAL INT RATE/12, INVESTMENT PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)
=FV(C8,C10,-5000) =FV(MONTHLY INT RATE, INVEST PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)

2. Create a formula using an excel function to fill the selected cell with interest rate based on data in row 4.
Here are the formulas I've tried.

=RATE(NPER,PMT,PV)
=RATE(E4,F4,B4) =rate(total no. periods(24), monthly payment, intial investment)
=RATE(NPER,PMT,PV,FV,0)
=RATE(E4,F4,B4,G4,0 =rate(total no. periods(24),monthly payment, initial investment, investment goal, 0)

3. Create a formula in the selected cell using CUMPRINC function and the data in the current worksheet that will calculate principal paid in the first 12 months of the loan when payments are made at the beginning of payment period.
Here are the formulas I've tried.

=CUMPRINC(RATE,NPER,PV,START,END,TYPE)
=CUMPRINC(C5,C7,C3,1,12,1)
=cumprinc(monthly int rate,invest period months,loan amount,1, 12, 1) =CUMPRINC(C4/12,C7,C3,1,12,1)
=cumprinc(annual int rate/12, invest period months, loan amount, 1, 12, 1)

4. Create a formula in the selected cell, using the CUMIPMT function and the data in the current worksheet, that will calculate the interest paid in the first 12 months of the loan. Loan payments are made at the beginning of payment period.
Here are the formulas I've tried.

=CUMIPMT(RATE,NPER,PV,START,END,TYPE)
=CUMIPMT(C5,C7,C3,1,12,1)
=cumipmt(monthly int rate,invest period months,loan amount,1,12,1)
=CUMIPMT(C5,C7,C8,1,12,1)
=cumipmt(monthly int rate,invest period months,monthly payment,1,12,1)

 

[UNNRE4LL]

1. Create a formula in the selected cell that will return the future value of savings that will result using the data in column C.
Here are the formulas I've tried.

=FV(RATE,NPER,PMT)
=FV(C7/12,C10,C6)
=FV(ANNUAL INT RATE/12, INVESTMENT PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)
=FV(C8,C10,-5000) =FV(MONTHLY INT RATE, INVEST PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)

 

[UNNRE4LL]

2. Create a formula using an excel function to fill the selected cell with interest rate based on data in row 4.
Here are the formulas I've tried.

=RATE(NPER,PMT,PV)
=RATE(E4,F4,B4) =rate(total no. periods(24), monthly payment, intial investment)
=RATE(NPER,PMT,PV,FV,0)
=RATE(E4,F4,B4,G4,0 =rate(total no. periods(24),monthly payment, initial investment, investment goal, 0)

 

[UNNRE4LL]

3. Create a formula in the selected cell using CUMPRINC function and the data in the current worksheet that will calculate principal paid in the first 12 months of the loan when payments are made at the beginning of payment period.
Here are the formulas I've tried.

=CUMPRINC(RATE,NPER,PV,START,END,TYPE)
=CUMPRINC(C5,C7,C3,1,12,1)
=cumprinc(monthly int rate,invest period months,loan amount,1, 12, 1) =CUMPRINC(C4/12,C7,C3,1,12,1)
=cumprinc(annual int rate/12, invest period months, loan amount, 1, 12, 1)

 

[UNNRE4LL]

4. Create a formula in the selected cell, using the CUMIPMT function and the data in the current worksheet, that will calculate the interest paid in the first 12 months of the loan. Loan payments are made at the beginning of payment period.
Here are the formulas I've tried.

=CUMIPMT(RATE,NPER,PV,START,END,TYPE)
=CUMIPMT(C5,C7,C3,1,12,1)
=cumipmt(monthly int rate,invest period months,loan amount,1,12,1)
=CUMIPMT(C5,C7,C8,1,12,1)
=cumipmt(monthly int rate,invest period months,monthly payment,1,12,1)

 

[UNNRE4LL]

1. Create a formula in the selected cell that will return the future value of savings that will result using the data in column C.
Here are the formulas I've tried.

=FV(RATE,NPER,PMT)
=FV(C7/12,C10,C6)
=FV(ANNUAL INT RATE/12, INVESTMENT PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)
=FV(C8,C10,-5000) =FV(MONTHLY INT RATE, INVEST PERIOD MONTHS, MONTHLY SAVINGS SET ASIDE)

 

[FDibbins]

Sounds like homework to me?