Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Corporate Finance

Authors: John B. Guerard Jr. Anureet Saxena, Mustafa Gultekin

2nd Edition

3030435466, 978-3030435462

More Books

Students also viewed these Finance questions

Question

What are the goals?

Answered: 1 week ago

Question

Are there other relevant characteristics about your key public?

Answered: 1 week ago

Question

What information remains to be obtained?

Answered: 1 week ago