fin303 wk 1 as 3 - 75674

Request Posted by
berkiebee

berkiebee

Rating : No Rating
Earned: $0
Request Detail
Price: $5
  • From: Business, Finance
  • Due on: Sat 01 Nov, 2014 (01:00pm)
  • Asked on: Fri 31 Oct, 2014
  • Due date has passed, but you can still Post Solution.
Description

Part One: Application, Time Value of Money Calculations

Download the Week 1 quantitative exercises called FIN3030_W1_A3_Template.xlsx.

Required:

Complete the assignment using the formulas embedded in Microsoft Excel and/or a financial calculator. Include an Excel document that shows your calculations.

Deliverable:

By Tuesday, November 4, 2014, submit the completed assignment using the Microsoft Excel template provided, to the W1: Assignment 3 Dropbox. Show all your calculations.

Name your document SU_FIN3030_W1_A3_part1_LastName_FirstInitial.

Part Two: Time Value of Money Problem

You would like to buy a new car in five years for cash. The price of the car today is $56,000 and you expect that the price will increase by 6% per year. You plan to save for this car starting today with a deposit in your savings account, which currently has a balance of $1,800 and earns 4% compounded annually.

You know that you will be receiving an inheritance of $3,500 three years from today, which you will deposit in your savings account for the car. If you make a deposit every month for the next five years beginning one month from today, how much will the deposit have to be in order for you to be able to pay cash for the car?

Required:

Complete the assignment using the formulas embedded in Excel and/or a financial calculator. Include an Excel document that shows your calculations.

Attachments
SUO_FIN3030_W1_Time_Value.xlsx
SUO_FIN3030_W1_...
1 Solution for fin303 wk 1 as 3
Title Price Category solution By purchased  
Part Two: Time Value of Money Problem
$6.00 Business, Accounting deepeyes 1 time(s)
Please Login or Register to Submit the Solution for the Request