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

Assume that you are the manager of a financially distressed

Assume that you are the manager of a financially distressed corporation, with $1.5 million in debt outstanding, which will mature in two months. Your firm currently has $1 million cash on hand. Assuming that you are oper ...

What is the relation between a strategy and an objective

What is the relation between a strategy and an objective? How are comparative advantages different from competitive advantages? What is a strategic plan? What is a financial plan, and how does it relate to a company's st ...

1 what are the characteristics of the nordic and

1. What are the characteristics of the Nordic and Scandinavian management culture at TietoEnator? 2. What ways can a company use to leverage its knowledge resources globally? 3. How does a rapidly growing startup maintai ...

Barilla is an italian multinational food company which

Barilla is an Italian multinational food company which ‘has significantly believed in B2B e-commerce and, in particular, in EDI (Electronic Data Interchange), especially in terms of Web-EDI, which supports the orderdeliv ...

1 what is the purpose of the accrual tranche could a cmo

1. What is the purpose of the accrual tranche? Could a CMO exist without a Z class? What would be the difference between the CMO with and without the accrual class? 2. Which tranches in a CMO issue are least subject to p ...

Jullian was curious if regular excise really helps weight

Jullian was curious if regular excise really helps weight loss,she decided to perform a hypothesis test. A random sample of 5 Kansas State students was chosen. The students took a 30-minute exercise every day for 6 month ...

Does depreciation affect cash flow in a positive or

Does depreciation affect cash flow in a positive or negative manner? From a net present-value perspective, why is accelerated depreciation preferable? Is it acceptable to utilize one depreciation method for tax purposes ...

1 write your point of view about the concept of risk and

1. Write your point of view about the concept of risk and return. Do you think they are related? What is the relationship, why is there one and how are they related? 2. In your opinion why should financial decision maker ...

We have seen that federal reserve chairman ben bernanke has

We have seen that Federal Reserve Chairman Ben Bernanke has argued that low interest rates in the United States during the mid-2000s were due to a global savings glut rather than to Federal Reserve policy. In an intervie ...

Each question will need be answered with 150 words1 explain

Each question will need be answered with 150 words. 1. Explain how we should go about computing the WACC for a project which uses both retained earnings and a new equity issue? 2. Explain why we multiply the component co ...

  • 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