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 are the main sources of revenue for banks2 why are

1. What are the main sources of revenue for banks? 2. Why are loans, which are usually liabilities, treated as assets for banks? 3. Why are savings accounts liabilities for banks? 4. Why are banks concerned with their lo ...

If asset as beta is greater than asset bs beta does this

If asset A's beta is greater than asset B's beta, does this mean that asset A has more risk than asset B? Explain? What is the difference between the security market line and the capital market line? How should an invest ...

Levi strauss amp company no longer made in the usalevi

LEVI STRAUSS & COMPANY NO LONGER "MADE IN THE USA" Levi Strauss & Company (LS&C) of San Francisco, California, has been in the clothing business for 150 years.The company developed and set the standard for denim jeans an ...

1 what factors should be considered when doing a

1. What factors should be considered when doing a cost-benefit analysis of a proposed study? 2. What is the purpose of the Institutional Review Board? 3. When is it not necessary to obtain informed consent?

On august 20 a stock index futures which expires on

On August 20 a stock index futures, which expires on September 20, was priced at 429.70. The index was at 428.51. The dividend yield was 2.7 percent. Discuss the concept of the implied repo rate on an index arbitrage tra ...

The cost of capital weighted average cost of capitalthe

The Cost of Capital: Weighted Average Cost of Capital The firm's target capital structure is the mix of debt, preferred stock, and common equity the firm plans to raise funds for its future projects. The target proportio ...

Consider the following analysis the rise and fall of a

Consider the following analysis: The rise and fall of a bond's price has a direct inverse relationship to its yield to maturity, or interest rate. As prices go up, the yield declines and vice versa. For example, a $1,000 ...

1 in what ways are experimental research designs preferable

1. In what ways are experimental research designs preferable to correlational or descriptive designs? What are the limitations of experimental designs? 2. What is the purpose of random assignment to conditions? 3. Descri ...

Bull how is consumer debt different today than in the

• How is consumer debt different today than in the past? • What role do interest rates play in mounting consumer debt? • What are the typical interest rates applied to credit cards, mortgages, and other debt? • Many of t ...

1 explain how the gold standard worked and why it led to

1. Explain how the gold standard worked and why it led to stable exchange rates. What might be some advantages and disadvantages of returning to the gold standard? 2. Describe the relationship between purchasing power pa ...

  • 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