Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

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.

a. find out the annual end of year loan payment amount.
b. Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.
c. Prepare a one page executive summary for the CEO, Linda Messineo, with the loan payment schedule describeing 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 find out the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927925

Have any Question? 


Related Questions in Basic Finance

1 what is the difference between moral hazard and adverse

1. What is the difference between moral hazard and adverse selection? How does each contribute to making information asymmetric? 2. Explain the "lemons problem." How does the lemons problem lead many firms to borrow from ...

The ok railroad needs to raise 95 million for capital

the O.K. Railroad needs to raise $9.5 million for capital improvements. One possibility is a new preferred stock issue - 8 percent dividend, $100 par value - stock that would yield 9 percent to investors. Flotation costs ...

Explain whether you agree or disagree with the following

Explain whether you agree or disagree with the following statement: "Unlike a dividend discount model, relative valuation seeks to explain the factors that determine the observed value of a share of common stock." To wha ...

In addition to the key words you should also be able to

In addition to the key words, you should also be able to define the following terms: within-subjects design between-subjects design independent-measures design assignment bias random assignment variance within treatments ...

What is the correct ranking for the following stocks

What is the correct ranking for the following stocks, highest to lowest, based on their total risk level? Night Ryder has an average return of 15 percent and a standard deviation of 35 percent. WholeMart has an average r ...

Explain the theory of purchasing power parity pppbased on

Explain the theory of purchasing power parity (PPP). Based on this theory, what is a general forecast of the values of currencies in highly inflated countries? Explain how you could determine whether purchasing power par ...

1 what do economists mean by a bubble why do many

1. What do economists mean by a "bubble"? Why do many economists believe that there was a housing bubble in the United States between 2000 and 2005? 2. By the 2000s, what significant changes had taken place in the mortga ...

1 why do level or constant monthly mortgage payments

1. Why do level or constant monthly mortgage payments increase so sharply during periods of inflation? What does the tilt effect have to do with this? 2. As inflation increases, the impact of the tilt effect is said to b ...

1 how has the community development block grant served to

1. How has the Community Development Block Grant served to help communities perform local mitigation? 2. Why do some people consider insurance to not be a proper mitigation method? 3. Why are structural controls a contro ...

Discuss the ethics of an advertisementon its website figure

Discuss the ethics of an advertisement. On its website (Figure 18), a company promises to deposit cash into a customer's bank account within 24 hours. In small groups, discuss tactics this company uses to persuade its au ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro