Determine the total cost of the loan

Assignment Help Cost Accounting
Reference no: EM131138539

Excel assignment

Background information

You are considering the purchase of a new car and taking out a loan. Here are the terms.

• Loan Amount: $35,000
• Interest rate:6.5%(Annual), compounded monthly
• Term: 60 months

Task #1: Determine the total cost of the loan (Payment per month * number of months). Payment per month can be found using the PMT function. =PMT(rate/12,term_in_months,loan_amount)

Task #2: Now that you have the total cost of the car and the initial loan amount, determine the total amount of interest paid on the life of the loan.

Task #3:Compute and show on the spreadsheet,themonthly balance and interest paid each month for all 60 months.

• Interest is paid each monthon the previous month's balance.
• The balance for each month is the previous month's balance, plus interest, minus the payment.

Also answer these questions

Assume that you can negotiate some of the terms. Determine how much you could save if you could negotiate a 10% better price, lower interest rate, or shorter term. You don't have to re-calculate the monthly balance for each scenario. This can easily be done by changing the values in the PMT function. If you have the total cost computed automatically, you can make the change and the new value will be computed.

Task #4: Recalculate total cost, total interest paid and monthly payment, with price lowered to $31,500 (10% off).

Task #5: Recalculate total cost, total interest paid and monthly payment,with interest lowered to 6.1%.

Task #6: Recalculate total cost, total interest paid and monthly payment,with length of loan reduced to 54 months.

Task #7: Which of the3 choices (Tasks 4, 5, 6) saves you the most total money (lowest total cost)? Mark clearly on the Excel sheet.

Task #8: Which of the 4 choices (original problem and Tasks 4, 5, 6) gives you the lowest total interest on the life of the loan? Mark clearly on the Excel sheet.

Task #9: Which of the 4 choices (original problem and Tasks 4, 5, 6) allows you to pay you the lowest monthly payments? Mark clearly on the Excel sheet.

How to submit

Upload the excel spreadsheet (NOT AS A PDF) to the assignment submission on eCampus showing all of the requested information (tasks 1-9). Make sure everything is aesthetically pleasingand clearly label and indicate your answers. You do not have to submit these directions.

Reference no: EM131138539

Questions Cloud

Did the companys inventories increase or decrease : Did the Company's "Inventories" increase or decrease over the last year? Were there more debits or credits to the Company's inventory accounts during 2014?
Explain humanitarian ethics : Humanitarian ethics provides a great bridge into practical application by showing how to apply theory to real-world ethical problems. Include the following in a three-page analysis: Explain humanitarian ethics.
Derive an equation for the factor of safety of the slope : Derive an equation for the factor of safety of the slope in Figure P16.2 using the mechanism shown.
Analyze the pros and cons of social contract theory : Discuss the philosophies of at least two social contract thinkers. Examples include: Hobbes, Locke, Jefferson, Nozick, and Rawls. Conclude with an exploration of what your perfect society/social contract would look like. What laws would you enact..
Determine the total cost of the loan : Determine the total cost of the loan (Payment per month * number of months). Payment per month can be found using the PMT function. =PMT(rate/12,term_in_months,loan_amount).
Determine the orthogonal projection pa of r onto axis a : Determine the scalar components Ra and Rb of the force R along the nonrectangular axes a and b. Also determine the orthogonal projection Pa of R onto axis a
What do you feel is significance of robert lack of vision : Look at Alice Walker's "Everyday Use" and explain how the quilts in the story symbolize the family's heritage. How do Dee and Maggie view the significance of the family's heritage, and how is that represented by the quilts in the story?
Prepare month end adjusting entry based on data for october : Prepare month end adjusting entries based on the following data for OCTOBER Record accrued interest on the long term note for 3 days - $13.56
Who benefits and who loses from protectionist policesies : Who benefits and who loses from protectionist policesies? - industries that use trade protected goods and inputs -trade protected industries.

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Balance sheet of patriot company

Illustrate how the information above should be shown on the balance sheet of Patriot Company

  The assignment aims to develop an understanding of

the assignment aims to develop an understanding of accounting information systems structure and their use in the

  Calculate multifactor productivity for the current process

Calculate the multifactor productivity for the current process and calculate the multifactor productivity for the new process

  Prepare the consolidation worksheet entries

Prepare the consolidation worksheet entries necessary for preparation of the consolidated financial statements for Geraldton Ltd and its subsidiary for the year ended 30/6/2012

  Calculate the cost of finished goods inventory

Ron Williams recently took over as the controller of Johnson Brothers Manufacturing. Last month, the previous controller left the company with little notice and left the accounting records in disarray.

  Calculate the eoq for heavy-duty tyres

What is the cost of the prediction error? Calculate the EOQ for heavy-duty tyres, along with the sum of annual relevant ordering costs and carrying costs.

  Question 1 a corporation has a june 30 year end what is the

question 1. a corporation has a june 30 year end. what is the last date it will file its return due for its june 30

  Approximate the current years balances

Approximate the current year's balances in the form of a balance sheet and income statement

  Determine amounts for items omitted from income statement

Determining amounts for items omitted from income statement - Determine the amounts of the missing items, identifying them by letter.

  Price and efficiency variances problems in standard-setting

price and efficiency variances problems in standard-setting benchmarking. new fashions manufactures shirts for retail

  Calculate total cost of direct materials used in production

Calculate the total cost of direct materials used in production. Calculate the cost of goods manufactured. Calculate the unit manufacturing cost.

  Beginning raw materials 43raw materials purchases 29raw

beginning raw materials 43raw materials purchases 29raw materials stolen 17. assume that the cost of raw materials

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