Car Loan Time Value of Money
Not what you're looking for?
DISCOUNT RATE IS: 10%
1) Buy car for $35,000. If bank will lend $30,000 (10% discount rate), what will annual payments be? Make 1st payment at end of year and make 5th and final payment at end of 5th year. SHOW IN EXCEL WITH "PAYMENT" FUNCTION
2) If payments were monthly, instead of annual, what would monthly car payment be? The first payment will be at the end of the month and the last payment will be at the end of the 60th month. Are the monthly payments 1/12th of your annual payments? Why or why not? SHOW IN EXCEL
3) Dealer offers to sell you car for $33,000 ($2,000 cash back) or charge you $35,000 and lend you $30,000 of the purchase price at 9%. Thus will make a $5,000 down payment and the annual payments based on a 9% rate or you will make a $3,000 down payment and make the five annual payments you solved for above (ie: loan payments based on 10% rate). How much cheaper is the discounted financing option? If it is more expensive, enter your answer as a negative number. Assume that the correct discount is still 10% when you value the two loans. SHOW IN EXCEL
Purchase this Solution
Solution Summary
The solution is provided in excel showing the difference between monthly and annual payments. The discount rate is 10%.
Education
- BA, Ain Shams University, Cairo Egypt
- MBA, California State University, Sacramento
Recent Feedback
- "ty i have more need help with"
- "ty i have jmore i need help with"
- "great help"
- "excellent help"
- "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.