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

Reviews

Write a Review

Mathematics Questions & Answers

  Determine approximate relative error after each iteration

If R = 3 m, to what depth must the tank be filled so that it holds 30 m3? Use three iterations of the false-position method to determine your answer. Determine the approximate relative error after each iteration

  If the material for each necklace costs terry 6 what should

during the summer months terry makes and sells necklaces on the beach. last summer he sold the necklaces for 10 each

  What is the probability that there will be a collision

what is the probability that there will be a collision? Round your answer to 4 decimal places. Remember to round all z values to two decimal places.

  Show that the adjustment coefficient is log

Show that the adjustment coefficient is log(3/2). If Un denotes the amount you have at time n, show that Un is not a martingale. At time 20 you have a total of 4 units. What is E((2/3)U50 )?

  Define the volume of wood in a tree varies jointly

The volume of wood in a tree varies jointly as the height and the square of the girth. Girth is the distance around. If the volume is 38.4 cubic feet, when the height is 30 feet and the girth is 4 feet,

  Information about dimensions of rectangle

The width of a rectangle is 1 foot less than the length. The area is 20 feet squared. Find the length and width.

  Find the speed of each train

the speed of a passenger train is 14 mph faster than the speed of a freight train. The passenger train travels 280 miles in the same time it takes the freight train to travel 210 miles. Find the speed of each train.

  What is the angle of elevation to the top of the tree

Child lies on the the ground and looks up at the top of a 17 foot tall tree nearby. Child is 14 feet away from the tree what is the angle of elevation to the top of the tree?

  Explain the differences on the set up of the equation

A person sees a ship on the horizon. Due to the curvature of earth, how far is the ship from the lighthouse - estimate how high above sea level you are and find how far the ship is from you.

  What percent tip did she leave

Christina takes her office co-workers to lunch. She gets the $140 bill, adds the gratuity, and as a result charges $170.80 on her credit card. What percent tip did she leave? Give answer as a percentage rounded to nearest tenth of a percent.

  How much is the discount on a soccer ball

Orins sports store has a 40% off sale on all of its merchandise. How much is the discount on a soccer ball that was originally costs $30

  Determining repeating decimals

Determine whether the following are equal. If not, which is smaller, and why?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd