### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### easy2understandexcel

##### Active Member
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

##### Well-known Member
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

##### New Member
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

##### New Member 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

##### New Member 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

##### New Member 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

##### New Member 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

##### New Member 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

##### Well-known Member
Sounds like homework to me?

Replies
4
Views
151
Replies
9
Views
158
Replies
2
Views
171
Replies
4
Views
449
Replies
1
Views
288

### Forum statistics

1,195,622
Messages
6,010,743
Members
441,567
Latest member
Flitbee ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back