RelativeResourceManager_ChengDing

RelativeResourceManager_ChengDing - Total Intere st Total...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Your Name: Cheng Ding Banner Number: A00347733 Loan Amortization Question Loan Amortization In A10, put the formula for Interest paid in pe Loan Amount $2,976.71 $9.30 Annual Interest 3.75% Monthly Payment $750 In A13, put the formula for total interest paid Loan Term 4.38 $9.30 0.31% Period Balance In A16, put the formula for principal paid in p 0 0 0 0 0 $2,976.71 $662.31 1 $9.30 $676.44 $9.30 $676.44 $3,653.15 2 $7.19 $678.55 ### $1,354.99 $5,008.14 In A19, put the formula for total principal paid3 $5.07 $680.67 ### $1,359.22 $6,367.36 $1,363.47 4 $2.94 $682.80 $8.01 $1,363.47 $7,730.83 In A22, put the formula for balance remaining in period 4 (I19): $7,730.83 Car Loan Question Car Loan Your Monthly Budget: $350.00 Lease: 5 Years Annual Interest: 3.35% Rate 0.28% Make Model Year an AmouMonthly Paymen Affordable? Infiniti FX35 60.00 ### $561.68 NO MercedesB200 60.00 ### $360.68 NO Mini CoopS 60.00 ### $344.19 YES Are the monthly payments for both the Vibe aPontiac Vibe 60.00 ### $199.28 YES Formula ChevroletUplander 60.00 ### $322.44 YES Yes Interest This Period Principal This Period
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Total Intere st Total Principal This is the area where you will be working. Column A has the instructions, and will be the column you print when you're done (with formulas showing). Please follow the directions about what to put where exactly. That one page should print cleanly, but check the print preview just to make sure. Make sure not to add or delete rows or columns (as this would change the formulas I'm marking). Feel free to add new values in other (empty) cells. Note also to fix pasted formulas (so that they still work) before submitting. Write one logical formula in A38 to display "yes" or "no" to answer the question in A36. Format the answer so that it displays as white text on a black background if the answer is "yes", and as regular black text on white if the answer is "no". Copy the value into A40. A B D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38...
View Full Document

Ask a homework question - tutors are online