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 political risk what are the important elements of

1. What is political risk? What are the important elements of political risk? How can companies prepare for political risk? 2. Discuss three of the world's major religions. What are some implications of these religions f ...

Design a randomized groups experiment to test the

Design a randomized groups experiment to test the hypothesis that children who watch an hour-long violent television show subsequently play in a more aggressive fashion than children who watch a nonviolent TV show or who ...

1 what does a z score below 2675 indicate according to the

1. What does a Z score below 2.675 indicate, according to the Altman model? 2. Indicate a practical problem with computing a Z score for a closely held firm. 3. No conclusive model has been developed to forecast financia ...

Explain why interest rate swaps are more widely used than

Explain why interest rate swaps are more widely used than currency and equity swaps? Explain how swaps are similar to but different from forward contracts? Suppose that a party engages in a swap, but before the expiratio ...

1 compare and contrast the theories of absolute and

1. Compare and contrast the theories of absolute and comparative advantage. 2. How does the Heckscher-Ohlin (HO) theory build on the earlier work of absolute and comparative advantage? 3. The Leontief Paradox finds oppos ...

1 in analyzing the data from an experiment why is it not

1. In analyzing the data from an experiment, why is it not sufficient simply to examine the condition means to see whether they differ? 2. Assuming that all confounds were eliminated, the means of the conditions in an ex ...

Borachera is a major spanish wine wholesaler currently

Borachera is a major Spanish wine wholesaler currently operating two CDCs in Salamanca and Albacete, and a number of RDCs all over the Iberian peninsula. In order to reduce its overall logistics cost, the company wishes ...

A project has a projected sales quantity of 810 units a

A project has a projected sales quantity of 810 units, a sales price of $56 a unit, a variable cost per unit of $38, and fixed costs of $5,200. All estimates are within a plus or minus range of 3 percent. You would like ...

Household budgetshould be in apa writing style1 create a

Household Budget Should be in APA writing style. 1. Create a simple household budget, including all income and expenses. There are various templates available online to help you do this. Find one that you feel comfortabl ...

What is operating cash flow ocf how is it calculatedwhat is

What is operating cash flow (OCF)? How is it calculated? What is free cash flow (FCF)? How is it calculated from OCF? Why do financial managers focus attention on the value of FCF?

  • 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