Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use excel , need help with functions and setting up cash flows in Excel because I am only used to using a financial calculator,
Please use excel, need help with functions and setting up cash flows in Excel because I am only used to using a financial calculator, thanks!
runctions). 9. You are considering buying a car from a local auto dealer. The dealer offers you one of two payment options You can pay $30,000 cash The "deferred payment plan" You can pay the dealer $5,000 cash today and a payment of $1,050 at the end of each of the next 30 months. As an altermative to the dealer financing, you have approached a local willing to give you a car loan of $25,000 at the rte of 1.25% per month. bank, which is Basic Financial Calculations a. Assuming that 1.25% is the opportunity cost, calculate the present value of all the payments on the dealer's deferred payment plan b. What is the effective interest rate being charged by the dealer? Do this calculation by preparing a spreadsheet like tis (only part of the spreadsheet is shown-you have to do this calculation for all 30 months): Payment under deferred Month Cash payment Difference payment plan 5,000 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050 30,000 25,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started