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 behavioral measures frequently have the advantage of

1. Behavioral measures frequently have the advantage of reducing participant reactivity. Since they can capture the behavior of individuals more honestly, why are they so infrequently used in behavioral research? 2. Cons ...

1 name two different ways that mptbs can be

1. Name two different ways that MPTBs can be overcollateralized. 2. What is a CMO? Explain why a CMO has been called as much of a marketing innovation as a financial innovation. 3. What is meant by a derivative investmen ...

1 what is meant by the term structural compression how does

1. What is meant by the term "structural compression"? How does this term affect logistics? 2. What is a horizontal company and how would this type of company be organized? What are the strengths of this type of organiza ...

1 describe one historical incident in which human

1. Describe one historical incident in which human participants were injured or abused as part of a research study. Describe how the injury or abuse would have been avoided if the researchers had followed today's ethical ...

If the binomial model produces a call option price that is

If the binomial model produces a call option price that is higher than the price at which the option is trading in the market, what strategy is suggested? Discuss how a binomial model accommodates the possibility of earl ...

1 explain the rationale behind time series designs2

1. Explain the rationale behind time series designs. 2. Describe the simple interrupted time series design. 3. Why is contemporary history a threat to internal validity in a simple interrupted time series design?

Name at least three reasons why some bolts fail

Name at least three reasons why some bolts fail mechanically ? What is the most common cause of bolted joint misbehavior or failure? Name at least two problems that can be caused by overtightening the bolts ? What do we ...

You are reviewing your targets for short-term cash reserves

You are reviewing your targets for short-term cash reserves next year. You wish to carry at least twenty days cash on hand. If annual budgeted cash expenses are $48,000,000, what amount of short-term cash reserves should ...

1 what is the difference between real property and personal

1. What is the difference between real property and personal property? 2. What is meant by an estate? 3. How can a leased fee estate have a value that could be transferred to another party? 4. What is an abstract of titl ...

Explain how you would conduct the study you designed in

Explain how you would conduct the study you designed in Question 1 as a matched-subjects design. Question 1 Design a randomized groups experiment to test the hypothesis that children who watch an hour-long violent televi ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen