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 some industries described in this chapter are controlled

1. Some industries described in this chapter are controlled by federal regulatory agencies. How does this affect their accounting systems? 2. When reviewing the financial statements of oil and gas companies, why is it im ...

Once a project is accepted country risk analysis for the

Once a project is accepted, country risk analysis for the foreign country involved is no longer necessary, assuming that no other proposed projects are being evaluated for that country. Do you agree with this statement? ...

The pressure rise across a pump p this term is proportional

The pressure rise across a pump P (this term is proportional to the head developed by the pump) may be considered to be affected by the fluid density ρ, the angular velocity ω, the impeller diameter D, the volumetric rat ...

1 what makes a good theory why are theories so important in

1. What makes a good theory? Why are theories so important in behavioral research? 2. What makes a theory falsifiable? What makes a theory tautological? 3. What is a research hypothesis? Why are research hypotheses, rath ...

1 why would a companys costs of manufacturing and

1. Why would a companys costs of manufacturing and procurement tend to increase as the firm changes from an MTP to an MTO strategy? Why would inventory costs tend to decrease? 2. How does a firms marketing strategy impac ...

1 describe why teams are being formed more frequently in

1. Describe why teams are being formed more frequently in business today. What are some of the special considerations required for a team to be successful? 2. Defend a position on the following question: Does radical org ...

1 budgets of government entitiesare integrated with the

1. Budgets of government entities: Are integrated with the financial accounting system. Enable governments to demonstrate compliance with laws and to communicate performance effectiveness. Are adopted by governments afte ...

You have recently been hired by swan motors inc smi in its

You have recently been hired by Swan Motors, Inc. (SMI), in its relatively new treasury management department. SMI was founded 8 years ago by Joe Swan. Joe found a method to manufacture a cheaper battery with much greate ...

Show how a combination of interest rate caps and floors can

Show how a combination of interest rate caps and floors can be equivalent to an interest rate swap? What are the advantages and disadvantages of an interest rate collar over an interest rate cap? Explain how the Black mo ...

Graph the means in figure 914 for the interaction between

Graph the means in Figure 9.14 for the interaction between self-esteem and ego threat. Does the graph look like one in which an interaction is present? Why or why not?

  • 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