Analysis data table for your car loan case

Assignment Help Operation Management
Reference no: EM132100665

Please use excel to do your analysis. Follow the steps and have a what if analysis data table for your car loan case. You are loaning 20,000 with 8.5 % interest for 60 months. In this scenario you need to pay $410 monthly. Use Excel’s PMT function to calculate monthly loan amount. What will your monthly payment be if you have different interest rates and terms (total term of months). Use Excel’s what if data table analysis to check various options with different interest rates and terms. (range your interest rates between 3% to 11% with 0.5 % increments, term as 24 months to 90 months increasing 6 months each time.) Also add data validation to loan amount. Prepare a list of various loan amounts (15,000 20,000 25,000) My Car Loan Loan Amount 20000 Term (months) 60 Interest Rate 8.5% Payment ($410.00)

Reference no: EM132100665

Questions Cloud

What was the speed of the baseball : A 0.034-kg bullet is fired vertically at 188 m/s into a 0.15-kg baseball that is initially at rest. The bullet lodges in the baseball and.
The features of both the apple ipad and samsung galaxy tab : Compare and contrast the available accessories, potential for future upgrades, warranties, and available support of both the iPad and the Galaxy Tab.
How would you describe carol leadership traits : How would you describe Carol’s leadership traits? How big a part did Carol’s traits play in the expansion of the company?
How far is the top of the window below the windowsill : A flowerpot falls off a windowsill and falls past the window below. You may ignore air resistance It takes the pot 0.420 s to pass from the top to the bottom.
Analysis data table for your car loan case : Follow the steps and have a what if analysis data table for your car loan case. Prepare a list of various loan amounts.
Determine the amount that he will get in account : If the man goes to withdraw the money after four years, determine the amount that he will get in his account?
What will be the final speed of an electron : A proton is released from rest at the positive plate of a parallel plate capacitor. It crosses the capacitor and reaches the negative plate with a speed.
Why do economists use models : Why do economists use models? Can complex real life labour markets be modelled by the efficiency wage model?
What is the angular momentum of the pencil : A pencil (mass 8 g and length 12 cm) is initially balanced so that it is sitting vertically on a flat table as shown in the figure below.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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