Question: Can someone Please help me answer this in Excel ONLY Also can you provide not just the answers but the functions Ex: =FV(B2,B3,,B6) Loan Analysis

 Can someone Please help me answer this in Excel ONLY Also

can you provide not just the answers but the functions Ex: =FV(B2,B3,,B6)

Can someone Please help me answer this in Excel ONLY

Also can you provide not just the answers but the functions Ex: =FV(B2,B3,,B6)

Loan Analysis Annual Interest Rate 6% Rate per Payments Quarter Payments (NPER) Annual Rate (RATE) 5 4 Quarterly Payment Future Value Financial Value Business Loan (FV) Years Quarterly Payment (PMT) $520,000 $100,000.00 Future Value (FV) $520,000 Payments (NPER) $520,000 0 Business Loan (PV) 5 4 4 O O 5 4 Problem #3. Fill in the loan analysis table to get the values in the shaded cells. (8) A. Row 6: The shaded cell in row 7 tells you the payment required to pay down a loan to $ 100,000 if paid periodically for 5 years. B. Row 7: The shaded cell in row 8 tells you how much of the loan you have left to pay (FV) if you make a periodic payment for 5 years. Assume that you make a $ 22,000 payment each period. C. Row 8: The shaded cells in row 9 tells the number of payments (and years) needed to pay off a loan if you make a $ 20,000 payment each period. D. Row 9: The shaded cell in row 10 tells you how much you could afford to borrow if you make periodic payments for 5 years to be able to pay off the loan at the end of the 5 year period.. Assume that you make a $ 18,500 payment each period for 5 years. Loan Analysis Annual Interest Rate 6% Rate per Payments Quarter Payments (NPER) Annual Rate (RATE) 5 4 Quarterly Payment Future Value Financial Value Business Loan (FV) Years Quarterly Payment (PMT) $520,000 $100,000.00 Future Value (FV) $520,000 Payments (NPER) $520,000 0 Business Loan (PV) 5 4 4 O O 5 4 Problem #3. Fill in the loan analysis table to get the values in the shaded cells. (8) A. Row 6: The shaded cell in row 7 tells you the payment required to pay down a loan to $ 100,000 if paid periodically for 5 years. B. Row 7: The shaded cell in row 8 tells you how much of the loan you have left to pay (FV) if you make a periodic payment for 5 years. Assume that you make a $ 22,000 payment each period. C. Row 8: The shaded cells in row 9 tells the number of payments (and years) needed to pay off a loan if you make a $ 20,000 payment each period. D. Row 9: The shaded cell in row 10 tells you how much you could afford to borrow if you make periodic payments for 5 years to be able to pay off the loan at the end of the 5 year period.. Assume that you make a $ 18,500 payment each period for 5 years

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!