Answered step by step
Verified Expert Solution
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
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 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 0Step 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