Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

ontentplayer/contentPlayer.aspx?system SAM&selectedMode; assessm Marble Falls Co

ID: 3814954 • Letter: O

Question

ontentplayer/contentPlayer.aspx?system SAM&selectedMode; assessm Marble Falls Community Library Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REMEW VIEW Conditional Fo General A A Calibri Format as Tabl cell styles Alignment Number Styles Font Marble Falls Community Library Investment Scenarios Net Income: $197,04S Aggressive savings Moderate savings Modest Savings 6 Monthly savings Set Aside: 7500 Annual nterest Rate 5.000 3,500 9 Month nterest Rate 9 Investment Penod years) 5.0% 10 investment period month) 11 Accrued Savings: 0.4% 60 60 510 60 Create a Question NOT savings in the selected cell that will return the of use that will the formula. using the data future column Time Remaining: No Limit Attempts Re

Explanation / Answer

Future Value of the selected column

=FV(C7/12,C10,-C6)   

You can verify the above formula for the agressive savings coloumn

it is producing the same result i.e 510046