Please download the attached Excel file, complete it according to the instructions, rename it using your last name and HWCh4 (example: FigueiredoHWCh4.xls) and then resubmit it as your homework solution. Questions 1 through 4 require you to type in the Excel built-in formulas to calculate the answer for each problem. Examples of the Excel formulas are included in the PDF of the video lectures for TVM-Future Value and TVM-Present Value. The Excel formulas must be entered into the Excel cells highlighted in light blue. Question 5 is primarily an Excel functionality exercise. Complete the missing items in the table that are highlighted in light blue. The purpose of this exercise is to illustrate how to use the Excel built-in TVM functions and also how to calculate the same results using the equivalent algebraic formula. The exercise can be completed in a few seconds (Yes, seconds, not minutes) by appropriately copying the formulas from the portions of the table already filled in. If you are not familiar with Excel try to learn how to copy/paste formulas from cells and what 'absolute cell reference' and 'relative cell reference' mean. Attachments Excel Homework-TVM 1.xlsx Next Previous 10 E Excel Klsha Scott Documents scottHW Ch4 Saved Home Iert Data Review View Tell me what you want to do Help Open in Desktop App Share Cab A A Cncy om Pe Jt Delee Format BIU S-% Conditional Fomat Fomatting- as Table Sort & ind & rSelect eas Algnment Number Taes Cebu fding e Vp.0,35,0 10000) Please solve the following Time Value of Money problems by using Excel's built-in functions. 1 What will be the ending balance for an account with an intal depot of $10,000 eaming 9% per year for 35 years? Enter solution using Excel fomula here 2 t you estimate you will need to have $750,000 in your retirement account when you retire in 30 yeans, how much munt you deposit today to reach that goal auming you can earm an annua oreturm of n% over that period? 2 Enber solution using Ecel fomla here S45300 4 gan anuretu of 8.5% How manyyeaswiake for $5.000 to grow into $300.000 a Sheet e Sot&Find Fer-Seleth Cear- Fomatting as Table Cipboand Font Algnment Number Tabes ng FV0.09,35,0-10000 B 3 How many years will it take for $15,000 to grow into $200,000 assuing an annual return of 85% 19 Enter solution using Excel formula here 31.7512574 4 Your fiem has paid $1 million for a project that is epected to eam a lump sum payment of $15 mon and nothing moe, in tn years Wht dcount e woud me the cument value of the project equal to the amount the firm paid? 24 Enter solution using Excel fomula here 25 26 5.Complete the table below that calculates the Future Value of S10.000 inveed at 7 % per year using penods from 1 to 10 years The table aso illustes the ale today of S0,000 to be receved in the future from 1 to 10 years later using a discount rate of 5% (Note: table is to be completed by approprately copyng the Ecel formula sing Ecelcpupeunctionalty should take just a few seconds to do it Sheet e Calibr Currency AutoSum Paste BIU $-% Conditional Format Formatting as Table Insert Delete Format Sort & Fim Fiter Sele Clear Unde Clpboard Font Alignment Number Tables Cells Editing D35 V(SDS49,C35,0-SE$49,0) G 5. Complete the table below that calculates the Future Value of $10,000 invested at 7 % per year using periods from 1 to 10 years. The table also illustrates the value today of $10,000 to be received in the future from 1 to 10 years later using a discount rate of 5 % ( Note : table is to be completed by appropriately copying the Excel formulas. Using Excel copy/paste functionality its 29 should take just a few seconds to do it). 30 31 32 Number of Future Value Future Value Present Value Present Value 33 Periods (Excel Formula) (Algebra Formula) (Excel Formula) (Algebra Formula) 34 35 $10,700.00 $11,449.00 $10,700.00 $9,523.81 $9,523.81 $9,070.29 36 $11,449.00 37 3 38 4 39 7 42 8 $6,13913 $6,139.13 10 Sheetl R Excel Klsha Scott Documents scottHW Ch4 Saved Home Iert Data Review View Tell me what you want to do Help Open in Desktop App Share Cab A A Cncy om Pe Jt Delee Format BIU S-% Conditional Fomat Fomatting- as Table Sort & ind & rSelect eas Algnment Number Taes Cebu fding e Vp.0,35,0 10000) Please solve the following Time Value of Money problems by using Excel's built-in functions. 1 What will be the ending balance for an account with an intal depot of $10,000 eaming 9% per year for 35 years? Enter solution using Excel fomula here 2 t you estimate you will need to have $750,000 in your retirement account when you retire in 30 yeans, how much munt you deposit today to reach that goal auming you can earm an annua oreturm of n% over that period? 2 Enber solution using Ecel fomla here S45300 4 gan anuretu of 8.5% How manyyeaswiake for $5.000 to grow into $300.000 a Sheet e N Southes U y Week 4 Excel w TM ScomwCh scom Chb verootnova-my sharepoint.com//pesonal/s573mynoedyout5/Doca oucedocdcac-25- s8 Excel Ksha Scott Documents scottHW Ch4 - Saved Fe Home Insert Data Revinw Tell me what you want to do View Help Open in Desktop App e share A A ecy Autm Pasde BIUD S-% 9 A eDeloma Condonal Fom Sort&Find & e-Selt Fomattingas Tl Clot Uv Nete te & ps5-io000 willt take for $15000 o grow ino5200.000 How many yea ng an an of s 11 Enter solution using cel foma her 1751254 4ur fim has paid Stion for a pct that s epected to eam a lump sumpaymentof$5mon andoig the project equl to the amount the fim paid tewould metheot wht d in er solution ungEe fo 25 here s.Complete the table below that cale the Futhure e of $0c00 d at peryear using pods fromto 10yeans The table aho rte the le today of S10.000 b din the future from 1 t0 30 years later uning dcount ae of 5%te table is to be completed by appopriatelyooing the fomas Usng cel onp tionality should tae st a few seconds to do Sheet Calb Crrency Autom Pae BTUD $-% Conditonal Fom Formatting as Table Jet Delte Format Oc Sot & Fm Fber Sele Clp ndo Font Aigment Number Tables Ce Edting D35 vSoS49 Casa-SES49,0 S.Complete the table below that caloulates the Future Value of $10,000 invested at 7% per year using periods from 1 to 10 years. The table aho ustrates the value today of $10,000 to be recved in the future from 1 to 10 years later using a dscount rate of 5% (Note table is to be completed by appropriately copying the Excel formulas Using Excel copy/paste functionalty 29 should take jst a few seconds to do 30 1 32 Number of Future Value Future Value (Algebra Formula) Present Value Present Value Perlods (Excel Formula) (Excel Formula) (Algebra Formula) 35 10,70000 1449.00 St0,00.00 $1144900 S85238 S952381 070 29 2 3 56139 13 SA 10 Sheet Calibri Currency AutoSum Paste BIU $-% % Conditional Format Insert Delete Format Sort & Fim Clear Formatting as Table Fiter Sele Undo Cpboard Font Alignment Number Tables Cells Editing D35 FV(SDS49,C35,0.SE$49,0) G 5. Complete the table below that calculates the Future Value of $10,000 invested at 7 % per year using periods from 1 to 10 years. The table also illustrates the value today of $10,000 to be received in the future from 1 to 10 years later using a dscount rate of 5 % (Note: table is to be completed by appropriately copying the Excel formulas. Using Excel copy/paste functionality its 29 should take just a few seconds to do it) 30 31 32 Number of Future Value Future Value Present Value Present Value 33 Periods (Excel Formula) (Algebra Formula) (Excel Formula) (Algebra Formula) 34 35 $10,700.00 $11,449.00 1 $10,700.00 $9,523.81 $9,523.81 $9,070.29 36 2 $11,449.00 37 38 4 39 5 8 $6,13913 $6,139.13 10 Sheetl