Messineo llc borrowed 15000 at a 14 annual rate of interest, Ask an Expert

Finance

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.

Calculate the annual end of year loan payment amount.

Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining 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 calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M91785629

Have any Question?Write your Review or question?

Related Questions in Financial Management

Assignment -complete a research topic and prepare a

Assignment - Complete a research topic and prepare a write-up, and a presentation. SECTION A: Financial Analysis and Pricing Select a portfolio of five firms from the industry of your choice. Please then see me for appro ...

Assignment 11set up an amortization schedule in excel that

Assignment 1 1. Set up an amortization schedule in Excel that caters to possible prepayments (or excess payments). The loan details are: $38,500, 6.5% APR, 5 year loan with Monthly payments. Show, on the spreadsheet, the ...

In red is the hypothesis you chose to write about use the

In red is the hypothesis you chose to write about. Use the hypothesis to write the research paper The Shadow Bank System If the shadow bank system is given a platform to develop, then it will provide a solution to the ba ...

Corporate financial management questions -part a -q1 200

Corporate Financial Management Questions - Part A - Q1. $200 invested today and earning 8 per cent per annum compounded semi-annually will grow to what amount at the end of three years? (A) $158.80 (B) $251.94 (C) $380.7 ...

1 identify one cyberattack that occurred in the last 2

1. Identify one cyberattack that occurred in the last 2 years. What caused the cyberattack? Do not repeat an example that has been posted previously. 2. How did the cyberattack impact data loss, financial loss, cleanup c ...

Assignment - capital asset pricing model and required

Assignment - Capital asset pricing model and required returns 1. Select two stocks that have prices available for the last ten years. (You may find it more interesting if you select one stock that is relatively risky and ...

Discussion as an initial response to the discussion topic

Discussion As an initial response to the discussion topic please create a Power Point presentation of 5 slides plus the title slide that contains the main results of part 2 of the Research Project. These slides should in ...

Scenario 1you know from government legislation that the

Scenario 1) You know from government legislation that the legal tax rate on your property is 2.4% and the city's assessed value of your property is $155,000. However, your property is currently on the market for only $60 ...

Discuss the following select a company that has been in the

Discuss the following : Select a company that has been in the news for ethical violations (for example, Enron). Assess the following in 525 to 700 words: Identify the alleged ethical violations. Determine why the violati ...

When looking at the life of a project plan it is useful to

When looking at the life of a project plan, it is useful to graph and outline the cost variance (CV), and schedule variance (SV). Determining progress, or lack of progress, provides essential information to assess a give ...

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

Recent Questions

Ask Financial Management Expert