File Home Insert Page Layout Formulas Data Review O Tell me what you want to do View Help X Cu 1A" A Calibr 2 Wrap Text General th Copy Paste Normal 2 Normal 3 A E E Merge & Center BIU Conditional Format as Good Formatting Table $-% 3 Format Painter Neutral Clipboard Font Alignment Number Style M13 B C F G K Amount Borrowed Value at End of Years Payments Total Annual Rate per Payment Investment per Year Payments Rate Payment Amount 2 425,000 n/a 325,000 250,000 n/a n/a 10 4 40 4.85% 1.21 % 3 3.22 % 5.20 % 10 12 120 0.27 % $ ( 10,000) 4 1.30 % $ ( 10,000) 0.51 % $ ( 12,000) $ (3,500) 4 5 10 12 120 6.15% 6 S 280,000 n/a 10 12 120 7 Cell references must be used for all parts of all formulas. 8 9 In row 2, for a $425,000 business loan that is repaid in 10 years at a 4.85 percent interest rate with quarterly payments, in H2 find the payment amount 10 11 12 In row 3, for a $325,000 investment at a 3.22 percent interest rate with monthly payments of $10,000 made over 10 years, in 83 calculate the value at 13 the end of ten years. 14 15 In row 4, for a $250,000 loan at a 5.2 percent interest rate that is completely repaid with quarterly payments of $10,000, in E4 find the number of payments that will be necessary to pay off the loan. Once E6 is complete, the value in C6 will display 16 17 In row 5, for monthly payments of $12,000 for 10 years at a 6.15 percent interest rate, in A5 to calculate the amount the company is borrowing 18 19 In row 6, for monthly payments of $3,500 for 10 years, in G6, find the monthly interest rate. Once G8 is complete, the annual rate in F8 will display. 20 21 22 23 24 Nm