80.2K

Verified Solution

Link Copied!

Need some helo with the last part of my lab

A B D Loan1 Loan2 Loan3 1 Kitchen Option C 2 ANNUAL RATE% 3 DURATION (YRS) 4 PERIODS/YR 5 PAYMENT 3 DOWNPAYMENT% 7 LOAN VALUE 3 BALOON PAYMENT the 8. You have decided to choose the option C kitchen and now want to explore some financing scenarios. A table has been setup on worksheet loan for this purpose. Insert the appropriate data inputs (using cell referencing to kitchen option C as needed) and write the appropriate Excel formulas needed to complete. Highlight the answer to each loan option in yellow. Loan 1 - Assume that you are making a down payment of 10% of the cost of the kitchen and borrowing the rest from the bank at 4.25% annual interest rate compounded monthly. The loan will be entirely paid off in 3 years. Determine your monthly payment. Page 2 of 3 Loan 2 - The bank has offered a loan for the entire value of the kitchen that you can pay off over a 3 year period with quarterly payments of $1500. What is the annual interest rate being charged for this loan? Loan 3 - The contracting firm also has financing terms available. They will lend you 80% of the cost of the kitchen with a 3.5% annual interest rate compounded monthly and a $500 balloon payment due at the end of the loan. You will make payments of $300/month. How many years will it take to pay off this loan? Which do you think is the best loan and why? Place answer below data on loan worksheet A B D Loan1 Loan2 Loan3 1 Kitchen Option C 2 ANNUAL RATE% 3 DURATION (YRS) 4 PERIODS/YR 5 PAYMENT 3 DOWNPAYMENT% 7 LOAN VALUE 3 BALOON PAYMENT the 8. You have decided to choose the option C kitchen and now want to explore some financing scenarios. A table has been setup on worksheet loan for this purpose. Insert the appropriate data inputs (using cell referencing to kitchen option C as needed) and write the appropriate Excel formulas needed to complete. Highlight the answer to each loan option in yellow. Loan 1 - Assume that you are making a down payment of 10% of the cost of the kitchen and borrowing the rest from the bank at 4.25% annual interest rate compounded monthly. The loan will be entirely paid off in 3 years. Determine your monthly payment. Page 2 of 3 Loan 2 - The bank has offered a loan for the entire value of the kitchen that you can pay off over a 3 year period with quarterly payments of $1500. What is the annual interest rate being charged for this loan? Loan 3 - The contracting firm also has financing terms available. They will lend you 80% of the cost of the kitchen with a 3.5% annual interest rate compounded monthly and a $500 balloon payment due at the end of the loan. You will make payments of $300/month. How many years will it take to pay off this loan? Which do you think is the best loan and why? Place answer below data on loan worksheet

Answer & Explanation Solved by verified expert

See Answer