Design Layout References Mailings Review View Help ally - Aarso EEEE 2 I ADAE AaBbCcDc AaBbCcDc AaBb C Normal No Spac... Heading 1 Editing Dictate Seni Paragraph Styles 12 Voice Sensit 5 . Complete the Bus Loan Schedule on the LoanInfo worksheet. Using the correct financial functions, calculate the Rate per Quarter and Total Number of Quarters. Use an appropriate function to calculate the Quarterly Payment in cell G5. Complete the Amortization Schedule using appropriate financial functions, relative and absolute cell references as applicable beginning in row 9. Copy D9:F9 to D10:F10. Insert a formula using relative cell references in cell io to calculate the Remaining Principal. Select C10:F10 and copy down to complete the table. Enter a formula to calculate the Final Balance in cell C29. Using CUMIPMT and CUMPRINC, relative and absolute cell references as applicable, calculate the interest and principal for year 1 in cells B36 and 137. Select B36:837 and copy across the range C36:F37. In cells G36 and G37, use AutoSum to calculate the total interest and principal over the course of the loan. BCMP_260_FINAL DATA 4. Saved. Search Dan FE Home Insert Draw Page Layout Formulas Data Review View Dwelopes Help Power Pivot 11 29 Custom -AA == BT. - A. Paste lil $ % 78% Conditional Format at Cell Formatting Table Styler Styles Doloto Et Format Sort & Find Filter See Editing Chaand Font Alignment Numbe B36 D 6 H 16 12 10 1 1 3 20 22 8 " 10 11 12 13 14 15 16 12 16 19 20 Final Balance $35,532 533036 $30,503 $27.932 $25,322 $22,621 $19.95 517250 514486 $11,674 SR20 $5024 52.984 SO $533 $496 $458 5419 $380 $140 S100 $250 $212 $375 5132 S8 $45 $9.4% $2,583 $2.71 $2.610 $2.649 $2,689 $2,239 $2,720 $2,811 $2,850 52.166 52,90 $2,000 20 $33,036 $30,503 $27,932 525,22 522,673 519.45 $17,256 $14,186 $11,674 $8,820 $5,924 $2,584 4 5 5 VO Interest and Principal Payments per Year Yew Year Year Year Years 14 1 Qur 19 17 35 4 20 Total Interest Pinal 10 Faculty Loaninfo Investment Design Layout References Mailings Review View Help ally - Aarso EEEE 2 I ADAE AaBbCcDc AaBbCcDc AaBb C Normal No Spac... Heading 1 Editing Dictate Seni Paragraph Styles 12 Voice Sensit 5 . Complete the Bus Loan Schedule on the LoanInfo worksheet. Using the correct financial functions, calculate the Rate per Quarter and Total Number of Quarters. Use an appropriate function to calculate the Quarterly Payment in cell G5. Complete the Amortization Schedule using appropriate financial functions, relative and absolute cell references as applicable beginning in row 9. Copy D9:F9 to D10:F10. Insert a formula using relative cell references in cell io to calculate the Remaining Principal. Select C10:F10 and copy down to complete the table. Enter a formula to calculate the Final Balance in cell C29. Using CUMIPMT and CUMPRINC, relative and absolute cell references as applicable, calculate the interest and principal for year 1 in cells B36 and 137. Select B36:837 and copy across the range C36:F37. In cells G36 and G37, use AutoSum to calculate the total interest and principal over the course of the loan. BCMP_260_FINAL DATA 4. Saved. Search Dan FE Home Insert Draw Page Layout Formulas Data Review View Dwelopes Help Power Pivot 11 29 Custom -AA == BT. - A. Paste lil $ % 78% Conditional Format at Cell Formatting Table Styler Styles Doloto Et Format Sort & Find Filter See Editing Chaand Font Alignment Numbe B36 D 6 H 16 12 10 1 1 3 20 22 8 " 10 11 12 13 14 15 16 12 16 19 20 Final Balance $35,532 533036 $30,503 $27.932 $25,322 $22,621 $19.95 517250 514486 $11,674 SR20 $5024 52.984 SO $533 $496 $458 5419 $380 $140 S100 $250 $212 $375 5132 S8 $45 $9.4% $2,583 $2.71 $2.610 $2.649 $2,689 $2,239 $2,720 $2,811 $2,850 52.166 52,90 $2,000 20 $33,036 $30,503 $27,932 525,22 522,673 519.45 $17,256 $14,186 $11,674 $8,820 $5,924 $2,584 4 5 5 VO Interest and Principal Payments per Year Yew Year Year Year Years 14 1 Qur 19 17 35 4 20 Total Interest Pinal 10 Faculty Loaninfo Investment