Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is my excel I created two data variable using years as row valuable and anual interest rate as column value but thats what i

image text in transcribedthis is my excel

image text in transcribed

I created two data variable using years as row valuable and anual interest rate as column value but thats what i got i am confused and dont know what i did wrong.

On part c do i use goal seek in what if analysis i am confused. Please help explain it.

In the Loan Analysis worksheet: a. Insert formulas in B7, B8, and B9 to compute the monthly payment for the loan, the total amoun of money that will be paid by the end of the loan, and the cost of the loan (total paid amour borrowed). b. In the range D4:H25 create a table that shows the cost of the loan for different combinations interest rates and years. Let Interest rates vary 2.25% to 7.25% in increments of 0.25%. Let year vary from 15 to 30 in increments of 5. Include labels for the table axes. C. Use conditional formatting to highlight loan costs over $100,000 in red and under $50,000 in greer d. You want your monthly payment to be exactly $1,000. Perform a what-if analysis to find out ho much you can borrow (cell B3) at the given interest rate (3.625%) and a 30-year loan. e. Format all cells appropriately. Stewart Financial Cost of the Loan Loan Amount Annual Interest Rate Years $50,000 3.625% 30 15 20 25 30 0 0 0 0 0 0 0 0 $ 0 0 0 0 Monthly Payment Total $ Payments Cost of the Loan 228.03 82,089.23 32,089.23 0 0 $ $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.25% 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 In the Loan Analysis worksheet: a. Insert formulas in B7, B8, and B9 to compute the monthly payment for the loan, the total amoun of money that will be paid by the end of the loan, and the cost of the loan (total paid amour borrowed). b. In the range D4:H25 create a table that shows the cost of the loan for different combinations interest rates and years. Let Interest rates vary 2.25% to 7.25% in increments of 0.25%. Let year vary from 15 to 30 in increments of 5. Include labels for the table axes. C. Use conditional formatting to highlight loan costs over $100,000 in red and under $50,000 in greer d. You want your monthly payment to be exactly $1,000. Perform a what-if analysis to find out ho much you can borrow (cell B3) at the given interest rate (3.625%) and a 30-year loan. e. Format all cells appropriately. Stewart Financial Cost of the Loan Loan Amount Annual Interest Rate Years $50,000 3.625% 30 15 20 25 30 0 0 0 0 0 0 0 0 $ 0 0 0 0 Monthly Payment Total $ Payments Cost of the Loan 228.03 82,089.23 32,089.23 0 0 $ $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.25% 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski PhD

3rd Edition

1567932320, 978-1567932324

More Books

Students also viewed these Finance questions

Question

4.1 Explain multiple uses of job analysis in HR decisions.

Answered: 1 week ago