Calculate the annual end of year loan payment amount

Assignment Help Financial Management
Reference no: EM131061237

Messineo LLC borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end of year payments. As the CFO of Messineo, LLC you must prepare a report of the pertinent information in a short summary for the CEO.

Calculate the annual end of year loan payment amount.

Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining why the interest portion of each payment declines with the passage of time.

Also, be sure to remind her that the interest portion of the loan payment is tax deductible. You should include your spreadsheet as an appendix to your executive summary to prove your figures in the loan payment schedule.

Hint: Using a spreadsheet, you will start with the PMT function to calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

Reference no: EM131061237

Questions Cloud

Beta of the new portfolio : You plan to use the proceeds to purchase another stock which has a beta equal to 0.9. What will be the beta of the new portfolio? Show your answer to 2 decimal places.
Estimate the number of actual trays required : A mixture of benzene and toluene containing 60 mole percent benzene is to be separated into an overhead product containing 96 mole percent benzene and a bottoms containing 25 mole percent benzene.
Interest rate earned on this deposit : If the bank returns $50 on a $1,000 deposit after one year, what is the interest rate earned on this deposit?
What percent of the maximum allowable flow rate is being use : what percent of the maximum allowable flow rate is being used
Calculate the annual end of year loan payment amount : Messineo LLC borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end of year payments. Calculate the annual end of year loan payment amount. Prepare a one page executive summary f..
Discuss the historical development of the group : What is the nature of their political activity during election years? How much money do they spend (are they connected to PACS or "superpacs")? Lobbyist?
About the free cash flow valuation : Free Cash Flow Valuation Dozier Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 9% rate. What is Dozier's term..
Failure of lehman brothers : What was the impact of the near failure of Bear Stearns and the failure of Lehman Brothers on Money Markets? What actions did the Federal Reserve and the Treasury Department take? What were the impacts of the decisions if any?
Estimate the pressure drop per tray as pounds : If the liquid density is 50 lb/ft3 and the gas density is 0.10 lb/ft3, estimate the pressure drop per tray as pounds force per square inch.

Reviews

Write a Review

 

Financial Management Questions & Answers

  Money invested in telemetry medical instruments

You have been employed by Telemetry Medical Instruments (TMI) for seven years and participate in their 401 (k) plan by having 5% of your paycheck invested in the plan. What does prudent investment management suggest that you do about risk?

  Repaid in equal annual installments

Big brothers, inc. borrows $116,647 from the bank at 19.39 percent per year, compounded annually, to purchase new machinery. This loan is to be repaid in equal annual installments at the end of ech year over the next 9 years. How much will each annua..

  Breaking up company and selling the parts create value

A multi-product company's breakup value equals the cash one could realize by splitting the company into two or more independent firms and disposing of each separately. A company becomes a candidate for a takeover when its market value falls below its..

  What are the zero-coupon rates implied by these bonds

Assume that there are two three-year bonds with face values equaling $1000. The coupon rate of bond A is .05 and .08 for bond B. A third bond C also exists, with a maturity of two years. Bond C has a face value of $1000; it has a coupon rate of 11%. ..

  Financial statements and forecasts for convenience

Size-up HCM using historical ratio analysis and a discussion of its business risk and financial risk and the Q1 tab reproduces HCM's financial statements and forecasts for your convenience.

  Law print the annual percentage rate

Master Card and other credit card issuers must by law print the Annual Percentage Rate (APR) on their monthly statements. If the APR is stated to be 18.00%, with interest paid monthly, what is the card's EFF%?

  What would cost of equity be if debt-equity ratio were zero

Crosby Industries has a debt-equity ratio of 1.6. Its WACC is 10 percent, and its cost of debt is 7 percent. There is no corporate tax. What is Crosby’s cost of equity capital? What would the cost of equity be if the debt-equity ratio were 0.4? What ..

  Calculate the dollar price increase and decrease

Consider a Zerobond (i.e., a bond that pays no coupon payment, meaning that the coupon rate on the bond is 0%) with a par value of $1,000 that will mature exactly 12 years from today. The current YTM of this Zerobond is 5.2%. Two years ago the YTM of..

  Labor-sales to tax-exempt entities

Rancco reported total sales of $73 million last year including $13 million in revenue (labor, sales to tax-exempt entities) exempt from sales tax. the company collects sales tax at a rate of 5%. in reviewing its information as part of its loan applic..

  Operating activity on the statement of cash flows

Which of the following items would not be classified as an operating activity on the statement of cash flows?

  Retail sales tax has become a popular way to finance state

The retail sales tax has become a popular way to finance state, county, and city governments as well as special districts. Which of these governments is the retail sales tax the best suited for and why? Which is it least suited for and why?

  Present value of an uneven stream of payments

(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window: Assuming a discount rate of 17 percent, find the present value of each ..

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