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?

Respond to this Question

First Name
School Subject
Your Answer

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 …
  3. Business

    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, …
  9. Business Math

    You can lease a $17,000 car for $500 per month. For how long (to the nearest year) should you lease the car so that your monthly payments are lower than if you were purchasing it with an 7%-per-year loan?
  10. college maths

    on an annual renewal lease, the quarterly lease payment on office space is $1600 payable in advance. what equivalent yearly payment made in advance would satisfy the lease if the interest is 6.5% compounded quaterly?

More Similar Questions