{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lazarow_Andrew_Assign#2

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

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

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%.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

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

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

View Full Document
Ask a homework question - tutors are online