# Financial Math

posted by .

Suppose that you decide to lease a car. At the end of the 48-month lease period, you need to make a lump-sum payment of \$5000 if you want to keep the car. You decide to save up, just in case you decide to keep the car; if you donâ€™t keep this car, you will still have saved a good down payment on a new car. You feel comfortable with saving \$70/month (over and above your lease payments). How high an annual nominal interest rate on savings do you need to accumulate \$5000 in 48 months, with interest compounded monthly?

How would I do this in Excel 2007? Is there a specific function I can use?

## Similar Questions

1. ### accounting

Can someone check my answers. A car dealership gives customers the choice of buying or leasing its cars. The cars cost \$20,000 and are sold for \$25,000. The standard lease contract is for four years, with the first payment made at …
2. ### Finance

I need help with this finance homework question PLEASE! Any help greatly appreciated! Your firm has been presented a leasing alternative on a new pizza dough machine. The annual lease payments would be \$135m. Tax rate is 40%. The lease …

Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing a leasing strategy for the next six months. Sundown leases cars from an automobile manufacturer and then rents them to the public on a daily …
4. ### Accounting

On June 30, 2011, Georgia-Atlantic, Inc., leased a warehouse facility from IC Leasing Corporation. The lease agreement calls for Georgia-Atlantic to make semiannual lease payments of \$585,423 over a three-year lease term, payable each …
5. ### ACC 400

Case 13-4 Application of SFAC No. 13 On January 1, 2006, Lani Company entered into a non cancelable lease for a machine to be used in its manufacturing operations. The lease transfers ownership of the machine to Lani by the end of …
6. ### Quantitative Methods

1. Management of Sundown Rent-a-Car (see Problem 8-8) has decided that perhaps the cost during the six-month period is not the appropriate Cost to minimize because the agency may still be obligated to additional months on some leases …
7. ### math

Debbie Snyder has just graduated from college and needs to buy a car to commute to work. She estimates that she can afford to pay about \$ 450 per month for a loan or lease and has about \$ 2,000 in savings to use for a down payment. …
8. ### Finance

After deciding to buy a new car, you can either lease the car or purchase it on a 3-year loan. The car costs \$32,000. The lease offer is for \$450/month for 36 months, with only \$99 due up front. If you buy the car with a 3-year loan, …