How much interest will you pay over the life of loan

Assignment Help Finance Basics
Reference no: EM132623509

Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. I expect the amortization schedule to be completed in Excel with all work shown in Excel. Thus, I should be able to click on any cell and see your work embedded in that cell. Do not use an online amortization schedule.

Note the textbook amortization schedule is using an annual payment. Please complete a schedule for both 180 months (15 years) and 360 months (30 years).

The interest rate for the year is 2.75% according to Bankrate for the area the home is in. Remember to divide your interest by 12 to get a monthly rate.

How much interest will you pay over the life of each loan? You can determine this by summing all the payments and subtracting the amount borrowed.

Reference no: EM132623509

Questions Cloud

Determine minimum three key indicators of health : Research if there are centralized or decentralized management of state responsibilities? Determine minimum 3 key indicators of health.
What the intrinsic value per share of the common stock is : What the intrinsic value per share of the common stock is? The firm's earnings per share had grown at 12% over the prior 5 years but the growth rate
Examine visual arguments in methods of persuasion : You have had a chance to see tools of persuasion in the Three Proofs and to examine visual arguments in methods of persuasion.
Identify the purpose of a whs code of practice : Define the term duty holder under WHS/OHS legislation and the primary duty of care of a PCBU under WHS legislation and Explain the process of risk assessment
How much interest will you pay over the life of loan : You can determine this by summing all the payments and subtracting the amount borrowed.
Find how much will earn in one week : Find How much will they earn in one week if they sell a $660,000 house? A real estate agent receives a basic retainer of $215 per week plus
Develop your vision of the ideal health care system : Develop your vision of the ideal health care system. List some of the characteristics that constitute such a system. What would be the goal or goals of your.
Unusual consumption of computing resources : Discuss the four types of incident candidates that are considered to be possible actual incidents. Unusual consumption of computing resources
What will book value be after eight years : Purchase a piece of machinery for my business for $9000. If has scrap value of $20 000 and a useful life of 12 years. What will its book value be after 8 years?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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