Compute the monthly payment for a home loan

Assignment Help Finance Basics
Reference no: EM132853832

As part of this post please create an amortization table based on the following question. After creating the amortization table graph the payment, interest and principal paid per month on one graph and include this in the EXCEL spread sheet in which you created your amortization table.

Compute the monthly payment for a $80,250 home loan. The interest of the loan is 5% with monthly payments. The loan amortization is over 25 years. Please enter the value of the home loan as your answer here. Post your amortization table and graph , please show full work so I can understand. link excel sheet.

Reference no: EM132853832

Questions Cloud

Compute the federal credits available to mrs vieux : Compute the federal credits available to Mrs. Vieux to minimize her tax payable
What is the pv of the uneven cash flow stream : What is the PV of the following UNEVEN cash flow stream if the annual interest rate is 6%? The payments are 100, 200, 200, 615, 600 in years 1 through 5
What is the ear of a credit card : What is the EAR (effective annual rate) of a credit card that has a stated rate of 15%? The credit card compounds interest monthly.
Determine the maximum amount that can be deducted : Determine the maximum amount that can be deducted by Mr. and Mrs. Jones for the year ending December 31, 2020 for child care expenses
Compute the monthly payment for a home loan : Compute the monthly payment for a $80,250 home loan. The interest of the loan is 5% with monthly payments. The loan amortization is over 25 years.
Compute the amount of the first months interest : -Compute the monthly payment for a $74,996 home loan. The stated interest of the loan is 5% with monthly payments. The loan amortization is over 25 years
Calculate joshs tax credits : Calculate Joshs tax credits - How would your answer change if Mack had a mental or physical infirmity
Differentiate market order from limit order with example : a) Suppose you have identified security A, B, and C as undervalued securities. Describe how you can select an optimal portfolio consisting of these three securi
How change in financial market affects portfolio revision : Describe the impact of correlation between securities in a portfolio on portfolio risk.

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine bad debt expense to the allowance method

Castle Company provides estimates for its uncollectible accounts. The allowance for uncollectible accounts had a credit balance of $17,880 at the beginning.

  Mindy and fred work for a large retail chain

Mindy and Fred work for a large retail chain. The chain's billionaire owner is a staunch fundamentalist Christian.

  What should be the price of baldwin stock today

Baldwin Corp. just paid a dividend of $2.00. Over the next two years this dividend is expected to grow by 20% per year. After two years, dividend growth is expected to level off at 10%. If the required rate of return on Baldwin stock is 12%, what ..

  Calculate the monthly payment for a 30-year mortgage

Calculate the monthly payment for a 30-year mortgage, where the amount borrowed is $100,000 and the annual interest rate is 6.0%.

  Consumer confidence survey

One of the indices that economists use to gauge consumer expectations is the consumer confidence survey. This is an indirect measure of consumer expectations

  Examine weight status

(Thee, and Zhong2008) surveyed under graduate college students to examine their weight status, health behaviors, and diet. Using body mass index, they classified the students into four categories: underweight, healthy weight, overweight, and obe..

  Computation of current price of stock

Computation of current price of stock and The current risk-free rate of return is 5% and the market risk premium is 8%

  What is the annual dividend yield

The stock of Pills Berry Company is currently selling at $80 per share. The firm pays a dividend of $3.30 per share.

  What is the firm''s roa

A firm has a profit margin of 15 percent on sales of $20,000,000. If the firm has debt of $7,500,000, total assets of $22,500,000, and an after-tax interest cost on total debt of 5 percent, what is the firm's ROA?

  Mid-size firm pension fund management team

Congratulations. You have been promoted to vice president and director of your mid-size firm's pension fund management team located in Cincinnati, OH. Before you have even had the opportunity to settle into your new office, your senior vice presid..

  Which contract would the manufacturer prefer

What must be the uniform annual sales volume of the product for Nadine to be indifferent between the contracts, based on a present worth analysis?

  How much checking up on the person was needed

How much difficulty did you have in getting the person to accept the delegation?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd