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

Given the following information on big brothers inc

Given the following information on Big Brothers, Inc. capital structure, compute the company's weighted average cost of capital (WACC). The company's marginal tax rate is 40%. Round the answer to two decimal places in pe ...

One of the uk divisions of global enterprises plc wishes to

One of the UK divisions of Global Enterprises plc wishes to set up a new manufacturing plant in Indonesia, because this would give it an important foothold in one of the fast growing parts of the world market, and would ...

A borrower is making a choice between a mortgage with

A borrower is making a choice between a mortgage with monthly payments or biweekly payments. The loan will be $200,000 at 6 percent interest for 20 years. a. How would you analyze these alternatives? b. What if the biwee ...

1 profits might be compared with sales assets or

1. Profits might be compared with sales, assets, or stockholders' equity. Why might all three bases be used? Will trends in these ratios always move in the same direction? 2. What is the advantage of segregating extraord ...

An investor estimates that next years sales for gyna inc

An investor estimates that next year's sales for Gyna Inc should amount to about 56 USD million. The company has 3.7 million shares outstanding, generates a net profit margin of about 8% , and has a payout ratio of 45%.a ...

1 what is the secondary mortgage market list three reasons

1. What is the secondary mortgage market? List three reasons why it is important. 2. What were the three principal activities of FNMA under its 1954 charter? What is its principal function now? 3. Name two ways that FNMA ...

What is the accounting identity list at least three of the

What is the accounting identity? List at least three of the assumptions underlying financial statements? Identify at least three current asset accounts ? What is the operating cycle ? Identify three current liability acc ...

We have conducted an election poll of 600 likely voters

We have conducted an election poll of 600 likely voters, collected as randomly as possible. The 95% confidence interval (CI) for those planning to vote for Senator Smith is about 55% +/- 4%. How many additional likely vo ...

1 what three rules govern the construction of a grouped

1. What three rules govern the construction of a grouped frequency distribution? 2. What is the difference between a histogram and a bar graph? 3. Distinguish among the median, mode, and mean.

Write a 750 to 1000 word paper in your paper include the

Write a 750 to 1000 word paper. In your paper include the following: Complete questions A through J for the Mini Case involving Shrieves Casting Company. Please complete the paper in actual paper format including an intr ...

  • 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