Lazarow_Andrew_Assign#2

Lazarow_Andrew_Assign#2 - Before doing anything, rename...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Before doing anything, rename this file as: lastname_firstname_assign#1 (go to file, then select save as) For example, white_julieAssign1 (do NOT put number symbol) This sheet has three parts: payment, future value and present value. PART #1: Payment Present Value $26,000 Interest Rate per period 8.34% # of Periods 20 Future Value 0 Periodic Payments ($2,506.47) PART #2: Future Value Principal Amount $9,300 Interest Rate per period 5.50% # of Periods 16 Periodic Payments $2,300 Future Value ($78,578.57) PART #3: Present Value Future Value $48,000 Interest Rate per period 14.50% # of Periods 32 Periodic Payments $12,600 Present Value ($86,385.89) Remember to do all three parts. You want to purchase a car. So you decided to take an Auto loan of $26000 (now). You are required to make payment at the start of every quarter. The annual interest rate is 8.34%. You have to pay off the loan in 5 years. Fill each cell in the table with the right value and calculate the periodic payment. A company's new project is expected to return $4200 at the end of every month for 8years. Also it is expected to get $48000 at the end of 8 years.The annual interest rate is 14.50%. Fill each cell in table with the right value and calculate the present value of all the future
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/18/2012 for the course WRT 307 taught by Professor Staff during the Fall '08 term at Syracuse.

Page1 / 4

Lazarow_Andrew_Assign#2 - Before doing anything, rename...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online