Reference no: EM131140700
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, the monthly balance and interest paid each month for all 60 months.
· Interest is paid each month on 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 the 3 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.
|
For the given scenario identify various classes
: Scenario: Universal Bank offers various services to its customers. The bank has various branches all over the country and, therefore, each branch has a unique code. For the given scenario, you have to identify various classes and their attributes
|
|
Explain the difference in a willful violation and a delibera
: Explain the difference in a willful violation and a deliberate indifference as those standards relate to a Section 1983 lawsuit by an inmate.
|
|
Provide recommendation for each issue identified in the case
: Identify the role you are playing. Analyze the issues (qualitatively and quantitatively); and provide a recommendation for each issue identified in the case.
|
|
Discuss role of financial management in public organizations
: Discuss the role of financial management in public service organizations. What are the major sources of financing for the federal government, state governments, the health sector, and the not-for-profit sector?
|
|
Compute the monthly balance and interest paid each month
: Compute and show on spreadsheet, monthly balance and interest paid each month for all 60 months. Recalculate total cost, total interest paid and monthly payment, with price lowered to $31,500 (10% off).
|
|
Explain the finance concepts found in the given readings
: Write a paper explaining the finance concepts found in the readings and how they relate to the context of the scenario.;Post your assignment as a Microsoft? Word attachment.
|
|
What inference can you draw from the numbers collected
: Note that the fiscal year for the federal government is October 1 - September 31. What inference can you draw from the numbers collected?
|
|
Provide explanation as why you selecte particular investment
: Select the highly marketable investment that you wish to research. Provide a brief (one paragraph) explanation as to why you selected that particular investment.
|
|
Discuss the importance of cash on hand
: Discuss the importance of cash on hand and how it affects the strength of the business. Would you agree that the amount of cash on hand is a factor when comparing like businesses?
|