Complete monthly loan payment schedule in space provided

Assignment Help Financial Management
Reference no: EM131527447

ank Y approved a loan of $150,000 at 4.5% APR compounded quarterly for your new home purchase. Complete the Monthly Loan Payment Schedule in the space provided below. Be sure to fill up all the spaces.

*If you can explain how to get the payment size(especially), principal and interest payment, total monthly, quarterly payment(especially) I can do every month. This is supposed to be in an excel document, so if you know of easy formulas I can use please let me know. Thank you

Loan Amount $150,000 Loan Period 15 Years APR (%) 4.5%

Quarterly Payment_______ Total Interest___________ Total Payment__________

Payment No.    Payment Size    Principal Payment    Interest Payment   Total Monthly Payment    Loan Balance

1

2

3

Reference no: EM131527447

Questions Cloud

Define the black-figure technique : Compare the Eleusis Amphora to the illustrations on the Dyplon Vase. Define the "black-figure" technique
Analysis - film terms and topics : Formal Analysis - Follow the directions for exercise two at the end of "Film Terms and Topics." Use Rear Window as your film. Write two pages instead of two paragraphs
Compliant information security program : Your briefing paper should fully answer the question "Why should our company adopt an ISO/IEC 27001 compliant Information Security Program?"
What environmental issues arise from the mine : Summarize what is mined there, how much economic activity it supports, what environmental issues arise from the mine?
Complete monthly loan payment schedule in space provided : Complete the Monthly Loan Payment Schedule in the space provided below.
What was massive retaliation : Who won the 1952 presidential election? What was massive retaliation? What was brinkmanship? What was the Eisenhower Doctrine
Discuss the advertising revenues : The following accounts have been adapted from recent financial statements of Time Warner.
Term paper-website migration project : Tony's Chips has recently been sold to a new independent company. The new company has hired you to manage a project that will move the old Website.
How important were regional differences in social aspects : How important were the regional differences in the social aspects of republicanism

Reviews

Write a Review

Financial Management Questions & Answers

  What will be the effective purchasing power

Fourteen years ago, the U.S. Aluminum Corporation borrowed $6.5 million. Since then, cumulative inflation has been 98 percent (a compound rate of approximately 65 percent per year). a. When the firm repays the original $6.5 million loan this year, wh..

  Calculate the unsystematic risk and firm specific risk

FINA 6001 Managing Finance Assignment. Calculate the daily market return over the last five years from the daily prices, calculate the monthly returns from the daily returns, and calculate the yearly returns from the monthly returns. Calculate the ..

  Statements related to financial risk

Which of the following statements related to financial risk are correct?

  Firm uses straight-line depreciation and borrows funds

Fargo North is considering the purchase of some new equipment costing $69,000. This equipment has a 2-year life after which time it will be worthless. The firm uses straight-line depreciation and borrows funds at a 8 percent rate of interest. The com..

  Define the various capital budgeting methods

Define the various capital budgeting methods such as net present value (NPV), internal rate of return (IRR), and so on, and explain how they differ from one another. Identify which, if any, of the methods discussed might be superior to the others and..

  Stock is expected to have year end dividend

A stock is trading at $85 per share. The stock is expected to have a year-end dividend of $3 per share (D1 = $3), and it is expected to grow at some constant rate g throughout time. The stock's required rate of return is 12%. What is your forecast of..

  What is the current price of the bond

What is the current price of the bond if the comparable rate of interest is 8 percent?

  What amount will be paid by the insurance company for loss

The insurance carrier used by Pinnacle Computer Systems specifies 65% coinsurance. What amount will be paid by the insurance company for the loss? Which of the following is likely to be a material component of an insurer’s revenue? Methods of dealing..

  Price of the bonds at each of the years to maturity

Assuming that the yield to maturity of each bond remains at 8.5% over next 4 years, calculate the price of the bonds at each of the following years to maturity.

  According to the law of demand

According to the law of demand, the higher the price of homes, the more likely it is that:

  Recall the mechanism behind continuous compounding

Recall the mechanism behind continuous compounding: the whole period is divided into increasing numbers of smaller and smaller sub-periods, and the resulting effective rate is calculated as a limit of the effective rates under increasing number of su..

  Advantage for share repurchases versus dividends

Describe why the way in which they distribute cash flow does not affect value, in perfect markets. Demonstrate how taxes can create an advantage for share repurchases versus dividends. Why are firms in different industries and countries have differen..

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