Question: 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

this is my excel I created two data variable using years asthis is my excel

row valuable and anual interest rate as column value but thats what

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

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!