Question: based on the down payment and mortgage infromation in table 2 calculate the variables below: loan amount, monthey payment on a 30 yr loan, total

based on the down payment and mortgage infromation in table 2 calculate the variables below: loan amount, monthey payment on a 30 yr loan, total interest paid over the life of a 30 year loan. Table 2: House Price: 398000 Down Payment: 15% 15yr loan interest rate: 3.90% monely periods in 15 year loan 180 30 year loan interest rate: 4.55% monthly periods in 30 year loan 360

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!

BL INCOME STATEMENT Sales COGS Other expenses Depreciation EBIT Interest Taxable income Taxes (40%) Net income 24,092,400 17,982,000 2,878,800 786,000 2,445,600 434,400 2,011,200 804,480 1,206,720...

House Price Down payment Based on the down payment and mortgage information in TABLE 2, calculate the variables below: To calculate payment, you must use the "PMT function in excel Be sure to enter...

Assignment: 1. Housing Costs Pick a city or area where you would like to live once you graduate. Determine the average cost of a 3-bedroom home in that area, and the typical closing costs in that...

Purpose: The purpose of this handout is to develop an amortization schedule for loan and to be able to answer"What if questions based on the data, An Amortistion schedule is complete table of...

help pls Use the inputs to complete the proforma. Al gold cells should have a formula (don't hard code numbers) Name: INPUTS 130,000 Gross Leasable Area (SF) Annual Rent $15.00 Vacancy Rate 5.0%...

Please calculate the effective yield for 10% rate where compounding periods are 1, 2, 4, 12 times per year. Please calculate the nominal rate of 9.5% EY where compounding periods are 1,2,4,12 times...

Joshua is ready to purchase a home requiring a $500,000 mortgage. He is considering two options: the monthly payment of $2,590 on a mortgage amortized over 25 years at a fixed rate of 3.79%,...

To answer the questions below: Include a statement at the end of each section. Describe the meaning of the numbers found. For instruction on how to submit the assignment review page 7 of the course...

I only need answers for 5 and 6 please... also show what formulas you use to solve. Thank you. Sierra Pacific Community College District Finance Office Student Loan Amortization Loan Amount 15,000.00...

A prospective first time home buyer is looking to purchase a new home for $400,000 by putting $80,000 down and securing a $320,000 mortgage. The buyer has gotten the approval for the mortgage and has...

Refer back to Table 5.2, which describes the subjects of information covered in the ACS. Imagine that you are thinking about locating very upscale restaurants in 10 different areas of the country and...

Refer to the preceding information for Fast Cools acquisition of Fast Airs common stock. Assume Fast Cool issues 40,000 shares of its $20 fair value common stock for 100% of Fast Airs common stock....

Between the RSU's, Options and ESPP plan the Zhao's have a lot of money in company stock. Discuss the benefits and disadvantages of being leveraged in company stock. Would you recommend they exercise...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...