Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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)
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 yearsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started