Build an excel spreadsheet to compute loan payment amount

Assignment Help Operation Management

Reference no: EM132092037

Project Requirements:

Build an Excel spreadsheet to compute a loan's payment amount and create a car loan Amortization Schedule -- based on the principal amount borrowed, the length of the loan and the annual interest rate.

Principal amount borrowed = $20,000;

Annual Interest Rate: 5.50%;

Payment interval is monthly payment;

# of Payments = 24;

Use Excel formula to calculate the monthly payment;

Create a schedule of payment (similar to the one shown in Appendix);

Appendix gives an example for your reference. You may design your worksheet

differently and may include the information of total interests paid;

Project outcomes:

Format your worksheet nicely and print it in one page as a PDF file. You need to print the file twice. One is showing the schedule, and the other showing the formulas. Make sure your print out includes a title, your name, and date.

Reference no: EM132092037

Questions Cloud

Exports beef to ireland and imports irish potatoes : What is intra-industry trade? if England exports beef to Ireland and imports Irish potatoes, would it be intra-industry trade?

What clinical manifestations are present : What clinical manifestations are present in Ms. G and what recommendations would you make for continued treatment? Provide rationale for your recommendations.

Decide on the best option for solving the problem : Generate options for solving the problem in the scenario. Evaluate the options for solving the problem. Decide on the best option for solving the problem.

Defining elements of a comprehensive health assessment : Describe the elements of a comprehensive health assessment of a geriatric patient. What special considerations should the nurse keep in mind while performing.

Build an excel spreadsheet to compute loan payment amount : Build an Excel spreadsheet to compute a loan's payment amount and create a car loan Amortization Schedule

Discuss what you can do as a nurse to support your clients : End-of-life care becomes an issue at some point for elderly clients. Even with the emergence of palliative care programs and hospice programs.

Discuss the plan of care in efforts to maintain compliance : After reading this article, I believe that the most impact on family members is that of the emotional impact. "Family members suffer greatly from the emotional.

How long did the first product take : Your company has just completed building 1000 products with an average time to build one to be 1.1448 hours. How long did the first product take?

What is the impact of a disease : The article reviewed that a wide variety of family members' lives can be affected, including emotional, financial, family relationships, education and work.

User Account

All Pages