Reference no: EM131187938
Bill has $25,000 in an investment account earning 6 percent per year. Bill decides to purchase a new car with a sticker price of $25,000. The car dealer offers Bill either $2,000 cash back or 2% financing for 5 years. If Bill takes the financing, he will make 60 equal monthly payments. Otherwise, he will pay $23,000 today for the car.
Calculate the monthly payment required if Bill agrees to the sticker price of $25,000 and finances the car at 2% per year.
Prepare the amortization schedule for the loan using an Excel spreadsheet.
Prepare a graph in Excel that shows the portion of each payment that goes to interest and the portion that goes to principal.
Based on the time value of money, should Bill take the $2,000 cash back or the 2% financing? Clearly explain and defend your choice.
|
What was the annual increase in the value of the comic book
: In 2012, an Action Comics No. 1, featuring the first appearance of Superman, was sold at auction for $1,650,000. The comic book was originally sold in 1943 for $.06. Required: For this to have been true, what was the annual increase in the value of t..
|
|
Which o?er has the highest present value
: Suppose you are selling a used car and there are two potential buyers. Buyer 1 o?ers to give you $3100 today and Buyer 2 o?ers to pay you in installments of $800 once each year for 4 years (with the rest installment paid today). Assuming you do not n..
|
|
Calculate gross patient revenue
: Determine the amount of net operating income that would result for a hospital whose payer mix and expected volume (100 cases) is as follows: Calculate gross patient revenue, deductions from gross patient revenue, net patient revenue, total expenses, ..
|
|
Calculate the retail price for sports fitness basket balls
: Randy Todd, marketing manager for New Waves Sports Products, Inc. (NWSP), is thinking about how changes taking place among retailers in his channel might impact his strategy. Calculate the retail price of the basketball for Kings sporting Goods. Calc..
|
|
Prepare the amortization schedule for the loan
: Bill has $25,000 in an investment account earning 6 percent per year. Bill decides to purchase a new car with a sticker price of $25,000. The car dealer offers Bill either $2,000 cash back or 2% financing for 5 years. Calculate the monthly payment re..
|
|
Define revenue and time value of money
: Define fee for service, discounted fee for service, charity services, and payment before service is delivered. Future value and present value concepts are extremely important to the role of financial management and impact cash flow. The response and ..
|
|
What were total liabilities and total long-term debt
: At year-end 2013, Wallace Landscaping’s total assets were $1.9 million and its accounts payable were $435,000. Sales, which in 2013 were $2.0 million, are expected to increase by 25% in 2014. Total assets and accounts payable are proportional to sale..
|
|
Leveraged and unleveraged capital structure
: Kelso Electric is debating between a leveraged and an unleveraged capital structure. The all equity capital structure would consist of 22,000 shares of stock. The debt and equity option would consist of 14,000 shares of stock plus $240,000 of debt wi..
|
|
What is its self-supporting growth rate
: Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,700,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..
|