I need alot of help with this part of my project. Im assuming i know what to do but im not 100% sure.

im not sure what information i need to fill out my monthly on my excel sheet

O Rate of Return Initial Investment 12 F G M N P Time Value of Money - Monthly Compounding Year 1 Month 1 2 3 5 G 7 8 9 10 11 12 Interest $0 $o $0$ $o SO $o $O $0 $0 Investment Valud SO $o $0 $o sol sol sol $0 sol sol SO SO so $0 Year 2 Month 1 2 3 4 5 6 7 8 9 10 Interest 11 $0 SO $0 $0 SO $o $0 so $0 Investment Value SO SO $0 sol SO $0 $0 SO SO SO $0 sol so so $o Year 3 Month 1 2 3 4 5 6 7 8 Interest 9 $0 SO 10 11 $0 12 $o SO $0 SO $0 Investment Value $0 SO sol $o $0 $0 so so sol 50 SO sol sol sol SOSO Year 4 Month 2 3 4 S 7 8 Interest 9 10 SO $0 11 $0 12 $0 so $o $O Investment Value $0 $0 $o so sol so $o $o sol sol SO so sol sol so solo Year 5 Month 2 2 3 4 5 6 7 8 Interest 9 10 $0 $0 so 11 12 SO $o$0 $0 Investment Value $0 SO $0 sol $0 sol sol $0 SO SO sol SO SO SO Year 6 SO $o $0 Month 1 3 4 5 6 7 Interest SO 8 9 10 so SO $o 11 $0 12 $0 Investment Value $0 $0 SO SO $0 $0 $0 sol sol SO SO sol so SO $0 sol Year 7 sos Month 1 2 3 4 5 6 7 interest 8 9 $0 $0 SO 10 11 so 12 $ OSO investment Value SOSO sol SO $0 SO sol SO so50 $0 SO $o $0 SO $0 sol $0 Year 8 Month 1 2 3 4 5 6 8 Interest SO 9 $0 $0 11 SO 10 $0 12 SO Investment Value SO $0 $0 sol SO sol SO so SO so so SO $0 sol soll Year 9 solo Month 1 2 3 4 5 6 7 Interest 8 9 so sol sol $0 10 11 12 $0 Investment Value sol $0 SO SO sol sol SO $0 SO soso $0 $0 so SO solo solo Month 1 2 3 5 6 Interest 2 B SO 9 10 so $0 $0 11 12 $0 Investment Value $0 50 50 so so $0 so $0 so SO SO $0 $0 so SO sol sol soll $0 Year 10 Business Summary Walt Disney is an entertainment company. Co 's segments are: Media Networks, which includes domestic cable networks, broadcast television network and domestic television stations, and television production and distribution Parks Experiences and Products, which includes theme parks and resorts and consumer products operations Studio Entertainment which includes motion picture production and distribution music production and stribution and post-production services and Direct-to-Consumer and international, which includes direct 1o-consumer streaming services, International television networks and channels and other digital content distribution platforms and services Key Executives Roberto Executive Chairman, Charman Age 68 Robert Check Chief Executive Officer Age 61 Pricing Summary Ago 73 Time Period 1 week Disney (Wal) Co. (The) Prke slan Braverman Senior Executive Vice President, General Counsel Secretary Christine McCaddy Senior Executive Vice President. Chief Pinancial Once Age 66 173 178 MPRE Executive Vice President, Chiet Human Resources Office Age 60 177 Share price (minor 175 Key Financials Un USD as of 041032021) 172 Income Statement 00130021 110001 00/1001 72021 Time sa Week Hang 10 ATS Revenue 50 m Net Income 4,513 EPS from Continuing Operation 249 EPS. Net Income ilud 250 Revenge per Share 32.11 Balance Sheet Total 200,250m TO 114/10 Shareholder 05 40m Torper the 11244 Not Antet per Share 4803 Cash Flows Cash from Operations 4297 Cash from investing 2.571m Cash from anong Cap. Exposures 2.067 Cash Flower Shore 235 Close Yesterday 172.42 NIA 5 Days 175.86 7,09233000 30 Days 17240 3.090.234.00 Volume 52 Week HighLOW Price Change 100 Days) 200 Day Moving Avg. 20101 109.10 12.55 1000 Thewand Management focus Have ETOA 40.000 001 0400 HOAN WDEN RO . (157 htter a come Reche Promo Phone are Weiteres With Odd card 78.000 21 CHO TAW to 11.58 PM (TYM EB Balance Show De Thousands Wa Rais 20 205.000 (TTM 8.251.000 ch TS000 To Longum A Mag 033 te se ne BI Ky lu lavui. 49 To Cara 31,5 2.000.000 200 534 Cash Dem Management Thousands TA10,000 Temely 6, LTD 1.430 6032.000 1721 DN CE 421 Cathog 55100 Call Sentinelas 18/2020 14.00 Our 275 Cm Cai Se UM 0.00 20 Com Estimate 2 2011 2010 tam LC ge 340 9.30 172. 12:17 S. 1551 We 11.2011 EHITA 5751 2003 125.53 TOP wy 9 Tay Horing Pag on 134 3 CURRENT RATIO (Current Assets / Current Liabilities) 4 Current Assets $28,124,000.00 $31,341,000 Tot Current Liabilities 0.897354903 Tot 7 8 -9 FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) TO 11 Current Assets Tot $1,044,000 $88,877,000 12 Current Liabilities -87833000 sha 13 15 DEBT RATIO (Total Debt / Total Assets) 16 17 Total Debt Ne $31,341,000 $28,124,000 18 Tot 1.114386289 Total Assets 19 20 21 22 23 EARNINGS PER SHARE (Net Income /Weighted Average Common Shares Outstanding) Net Income Shares Outstanding $93,889,000 $116,361,000 Ne Tot 0.806876875 24 25 28 27 PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) NI 28 29 Stock Price EPS $4,597,000 $116,361,000 0.039506364 She 30 31 32 TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) Total Revenue $93,889,000 $28,124,000 Total Assets 3.338394254 Total Assets $28,124,000 $31,341,000 Shareholder's Equity 0.897354903 NET PROFIT MARGIN (Net Income / Total Revenue) Net Income $125,000 $4,722,000 Total Revenue 0.026471834 RETURN ON ASSETS (Net Income /Total Assets) Net Income Total Assets $93,889,000 $28,124,000 3.338394254 RETURN ON EQUITY (Net Income Preferred Dividends / Shareholder's Equity) NI - Pref. Div. Shareholder's Equity $93,889,000 $88,877,000 1.056392543 O Rate of Return Initial Investment 12 F G M N P Time Value of Money - Monthly Compounding Year 1 Month 1 2 3 5 G 7 8 9 10 11 12 Interest $0 $o $0$ $o SO $o $O $0 $0 Investment Valud SO $o $0 $o sol sol sol $0 sol sol SO SO so $0 Year 2 Month 1 2 3 4 5 6 7 8 9 10 Interest 11 $0 SO $0 $0 SO $o $0 so $0 Investment Value SO SO $0 sol SO $0 $0 SO SO SO $0 sol so so $o Year 3 Month 1 2 3 4 5 6 7 8 Interest 9 $0 SO 10 11 $0 12 $o SO $0 SO $0 Investment Value $0 SO sol $o $0 $0 so so sol 50 SO sol sol sol SOSO Year 4 Month 2 3 4 S 7 8 Interest 9 10 SO $0 11 $0 12 $0 so $o $O Investment Value $0 $0 $o so sol so $o $o sol sol SO so sol sol so solo Year 5 Month 2 2 3 4 5 6 7 8 Interest 9 10 $0 $0 so 11 12 SO $o$0 $0 Investment Value $0 SO $0 sol $0 sol sol $0 SO SO sol SO SO SO Year 6 SO $o $0 Month 1 3 4 5 6 7 Interest SO 8 9 10 so SO $o 11 $0 12 $0 Investment Value $0 $0 SO SO $0 $0 $0 sol sol SO SO sol so SO $0 sol Year 7 sos Month 1 2 3 4 5 6 7 interest 8 9 $0 $0 SO 10 11 so 12 $ OSO investment Value SOSO sol SO $0 SO sol SO so50 $0 SO $o $0 SO $0 sol $0 Year 8 Month 1 2 3 4 5 6 8 Interest SO 9 $0 $0 11 SO 10 $0 12 SO Investment Value SO $0 $0 sol SO sol SO so SO so so SO $0 sol soll Year 9 solo Month 1 2 3 4 5 6 7 Interest 8 9 so sol sol $0 10 11 12 $0 Investment Value sol $0 SO SO sol sol SO $0 SO soso $0 $0 so SO solo solo Month 1 2 3 5 6 Interest 2 B SO 9 10 so $0 $0 11 12 $0 Investment Value $0 50 50 so so $0 so $0 so SO SO $0 $0 so SO sol sol soll $0 Year 10 Business Summary Walt Disney is an entertainment company. Co 's segments are: Media Networks, which includes domestic cable networks, broadcast television network and domestic television stations, and television production and distribution Parks Experiences and Products, which includes theme parks and resorts and consumer products operations Studio Entertainment which includes motion picture production and distribution music production and stribution and post-production services and Direct-to-Consumer and international, which includes direct 1o-consumer streaming services, International television networks and channels and other digital content distribution platforms and services Key Executives Roberto Executive Chairman, Charman Age 68 Robert Check Chief Executive Officer Age 61 Pricing Summary Ago 73 Time Period 1 week Disney (Wal) Co. (The) Prke slan Braverman Senior Executive Vice President, General Counsel Secretary Christine McCaddy Senior Executive Vice President. Chief Pinancial Once Age 66 173 178 MPRE Executive Vice President, Chiet Human Resources Office Age 60 177 Share price (minor 175 Key Financials Un USD as of 041032021) 172 Income Statement 00130021 110001 00/1001 72021 Time sa Week Hang 10 ATS Revenue 50 m Net Income 4,513 EPS from Continuing Operation 249 EPS. Net Income ilud 250 Revenge per Share 32.11 Balance Sheet Total 200,250m TO 114/10 Shareholder 05 40m Torper the 11244 Not Antet per Share 4803 Cash Flows Cash from Operations 4297 Cash from investing 2.571m Cash from anong Cap. Exposures 2.067 Cash Flower Shore 235 Close Yesterday 172.42 NIA 5 Days 175.86 7,09233000 30 Days 17240 3.090.234.00 Volume 52 Week HighLOW Price Change 100 Days) 200 Day Moving Avg. 20101 109.10 12.55 1000 Thewand Management focus Have ETOA 40.000 001 0400 HOAN WDEN RO . (157 htter a come Reche Promo Phone are Weiteres With Odd card 78.000 21 CHO TAW to 11.58 PM (TYM EB Balance Show De Thousands Wa Rais 20 205.000 (TTM 8.251.000 ch TS000 To Longum A Mag 033 te se ne BI Ky lu lavui. 49 To Cara 31,5 2.000.000 200 534 Cash Dem Management Thousands TA10,000 Temely 6, LTD 1.430 6032.000 1721 DN CE 421 Cathog 55100 Call Sentinelas 18/2020 14.00 Our 275 Cm Cai Se UM 0.00 20 Com Estimate 2 2011 2010 tam LC ge 340 9.30 172. 12:17 S. 1551 We 11.2011 EHITA 5751 2003 125.53 TOP wy 9 Tay Horing Pag on 134 3 CURRENT RATIO (Current Assets / Current Liabilities) 4 Current Assets $28,124,000.00 $31,341,000 Tot Current Liabilities 0.897354903 Tot 7 8 -9 FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) TO 11 Current Assets Tot $1,044,000 $88,877,000 12 Current Liabilities -87833000 sha 13 15 DEBT RATIO (Total Debt / Total Assets) 16 17 Total Debt Ne $31,341,000 $28,124,000 18 Tot 1.114386289 Total Assets 19 20 21 22 23 EARNINGS PER SHARE (Net Income /Weighted Average Common Shares Outstanding) Net Income Shares Outstanding $93,889,000 $116,361,000 Ne Tot 0.806876875 24 25 28 27 PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) NI 28 29 Stock Price EPS $4,597,000 $116,361,000 0.039506364 She 30 31 32 TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) Total Revenue $93,889,000 $28,124,000 Total Assets 3.338394254 Total Assets $28,124,000 $31,341,000 Shareholder's Equity 0.897354903 NET PROFIT MARGIN (Net Income / Total Revenue) Net Income $125,000 $4,722,000 Total Revenue 0.026471834 RETURN ON ASSETS (Net Income /Total Assets) Net Income Total Assets $93,889,000 $28,124,000 3.338394254 RETURN ON EQUITY (Net Income Preferred Dividends / Shareholder's Equity) NI - Pref. Div. Shareholder's Equity $93,889,000 $88,877,000 1.056392543