Solution-Calculate the annual payment

Calculate the annual payment

Assignment Help Mathematics

Reference no: EM131458634

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 (executive summary) of the pertinent information in a short summary for the CEO.

1. Calculate the annual end of year loan payment amount.

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

3. 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.

Reference no: EM131458634

Questions Cloud

What quantities of h and w will maximize profits : An appliance manufacturer produces two models of microwave ovens: H and W. Both models require fabrication and assembly work;

What are the two factors of person perception of an object : What are the two factors that interact to create a person's perception of an object? How is this important for marketers?

Review article on assessing your companys global potential : After reading the Harvard Business Review article on assessing your company's global potential, post your thoughts and comments on the authors' main conclusions

Selling computer-software products to providing it services : Xerox goes from selling computer and software products to providing IT services.

Calculate the annual payment : 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.

Discuss your approach to pricing and incentives : While finding the monetary donors we would also need to start searching for restaurant donors as well who would provide the leftover food to us.

How both small and large organization can utilize technology : explain how both small and large organizations can utilize technology to assist organizations and their project managers in costing and budgeting a project.

What are the components of attitude : What are the components of attitude? Explain the two ways in which marketers can try to change consumer attitudes toward their products.

Evaluate the financial aspects of making decisions : In this assignment, you will evaluate the financial aspects of making decisions. Tasks: Investigate any two of the following four financial decisions

User Account

All Pages

Calculate the annual payment

Reference no: EM131458634

Reference no: EM131458634

Questions Cloud

Reviews

Write a Review

Mathematics Questions & Answers

Questions on ferris wheel

Logistic map

Finding the probability of cards

Systems of ode

Derive the boolean expression

System of equations

Linear programming problem

Find the natural domain

Introduction to numerical methods

Chart of the topological manifold

Mathematics in computing

Complex problems

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT