Please use excel then show the formula. and screenshot 6. Assume that you want to buy...

Please use excel then show the formula. and screenshot

6. Assume that you want to buy a home. You find a home for which you will owe $140,000 after paying the down payment. Assume that you are able to get a 5% mortgage loan for 30 years. Payments are made monthly in arrears (at the end of the month). At the end of the 30 years, you will have paid off the entire loan. A) How much will your monthly payments be? (Hint: I recommend that you use the PMT formula available in Excel to solve this problem. You can access the Help menu to help you learn how to use the PMT function.) Remember, the loan payments are made on a monthly basis and the interest rate is 5% per year. B) What is the total amount that you will have paid in loan payments at the end of the 30 years?

7. Use the information from Question 6 except assume that the interest rate is 4%. A) How much will your monthly payments be? B) What is the total amount that you will have paid in loan payments at the end of the 30 years?

8. Use the information from Question 6 except assume that the interest rate is 6%. A) How much will your monthly payments be? B) What is the total amount that you will have paid in loan payments at the end of the 30 years? 9. Use the information from Question 6 except assume that you get a 15-year mortgage loan instead of a 30-year loan and a 5% interest rate. A) How much will your monthly payments be?

B) What is the total amount that you will have paid in loan payments at the end of the 15 years?

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Please explain your answers and use Excel to show the excel formula you used to get...

Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.

Kindly do on excel and screenshot with formulas. 1. You are ready to buy a house...

Kindly do on excel and screenshot with formulas. 1. You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $200,000. The bank is willing to allow your housing costs – mortgage, property tax, and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and...

PLEASE SHOW WORKING AND FORMULA STEP BY STEP. DO NOT USE EXCEL Blitz Industries has a...

PLEASE SHOW WORKING AND FORMULA STEP BY STEP. DO NOT USE EXCEL Blitz Industries has a debt-equity ratio of .6. Its WACC is 9.2 percent, and its cost of debt is 6.5 percent. The corporate tax rate is 23 percent. a. What is the company’s cost of equity capital? b. What is the company’s unlevered cost of equity capital? c-1. What would the cost of equity be if the debt-equity ratio were 2? c-2. What would the cost of...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired return goal? Stock X Stock Y Expected Return 14.0% 9.0% Goal Return of Portfolio: 10.00% Dollar Amount to Invest: $20,000

Use Excel to show your work and include the formula in the cell to show how...

Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...

Show work (excel if possible but show formulas you used in excel): If I buy a...

Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?

Show work (excel if possible but show formulas you used in excel): If I buy a...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality rain gear for outdoor enthusiasts. Management prepared a forecast of sales (in suits) for next year and now must prepare a production plan. The company has traditionally maintained a level workforce strategy. All nine workers are treated like family and have been employed by the company for a number of years. Each employee can produce 2,000 suits per month. At present, finished goods inventory...

Subjects