File Home Insert Arial 10 A A ag Currency LA $ ~ % 9 08 20 Conditional Format as Cell Delete Paste B I UV Formatting v Table Styles v Format Clipboard Font Alignment N Number Styles Cells B7 v I X V fx =PV(C7,F7,-H7) A B C D E F G H J K 1 Car Analysis annual Balloon Can afford interest # periods Payment Payment or with 2 Car Selling Price rate % down Loan Amount # yrs per year per period FV inheritence 3 Taurus $ 22,300 4.8% 5% $ 21,185 5 12 $ (398) $ FALSE 4 Thunderbird 24,300 6.8% 20% $ 19,440 8.17 12 $ (259) $ FALSE Focus 15,799 3.5% 10% $ 14,219 5 12 $ (225) $ (2,204) TRUE Windstar $ 17,999 12.5% 5% $ 17,099 3 4 $ (1,730) $ TRUE 7 Mustang ($1,224) 6.2% 0% $ (1,224) 4.5 12 $ (320) $ TRUE 8 Question 8 $10,473.75 TRUE 9 10 11 12 13 14 15 16 17 18 19 20 Cars Outlook Ready Accessibility: Good to go o W T DELLA B C D E F G H Car Analysis annual Balloon Can afford Interest # periods |Payment Payment or with 2 Car Selling Price rate % down Loan Amount #yrs per year per period FV inheritence 3 Taurus $ 22,300 4.8% 5% $ 21,185 5 12 $ (398) S FALSE 4 Thunderbird $ 24,300 6.8% 20% $ 19,440 8.17 12 $ (259) S FALSE 5 Focus 15,799 3.5% 10% 14,219 5 12 $ (225) $ (2,204) TRUE 6 Windstar $ 17,999 12.5% 5% $ 17,099 3 4 $ (1,730) $ TRUE 7 Mustang $15,045 6.2% 0% $ 15,045 4.5 12 $ (320) TRUE 8 Question 8 $10,473.75