let me know if any pictures are hard to see. thank you in advance!

Calibri 11 CURRENT RATIO (Current Assets/Current Liabilities) FON/01 WORKING CAPITAL (Cument Assets Current Liabilities) DEST RATIO (Total Usblities/Total Assets) NOIVA LARNINGS PER SHARE the income/Weighted Average Common Shares Outstanding) DIVA PRICE EARNINGS NATIO (Share Price (end of quarter/15S tes FOIVAS Morithly Annual PV fx Total Assets GB I U S ACCOUNTING & FINANCIAL RATIOS Total Revenue Total Assets RATIOS FV aA- *** y TOTAL ASSET TURNOVER RATIO (Total Revenue/Total Asset ON/O FINANCIAL LEVERAGE (Total Assets/Shareholder Equity) #DIV/0! NET PROFIT MARGIN (Net Income/Total Revenue RETURN ON ASSETS (Net income/Total Assets) TA COMADI RETURN ON EQUITY (Net Income Preferred Dividends/Shareholder's Equity Fudby Sher's s #DIV/01 PV-Lump Sum FV-Lump Sum Net T holder's Ey NPV #DIV/01 2 F 1 2 Rate of Return 3 Initial investment 9 fx 10 11 32 14 10 10 17 15 10 20 21 22 114 27 29 30 32 33 PE 35 34 37 38 43 45 HE 48 49 An U D D Month Interest Month interest Investment Value Month Interest Investment Value Month Interest Investment Value Month Interest Investment Value Month interest investment Value Month Interest Investment Value Month Interest Month Interest Investment Value Month Interest Investment Value 1 1 11 1 1 1 50 So 50 1 05 05 50 50 $0 $0 50 sol 50 50 501 50 10 50 F 05 2 2 2 2 2 2 2 2 50 (05 0$ 2 05 05 $0 $0 50 0$ 50 501 05 50 105 sol 3 50 50 sol 50 50 G H Time Value of Money Monthly Compounding Year 1 3 4 5 7 8 50 $0 50 50 50 So so Year 2 3 3 3 1 1 50 05 50 50 05 50 05 05 50 39 50 $0 501 50 105 50 50 50 50 4 4 4 A 4 4 17 4 4 05 50 50 sol 50 sol 50 50 50 105 0% 50 05 50 50 501 50 05 5 5 5 5 15 5 S 0$ 5 50 Year 3 $0 50 Year 4 50 50 Year 5 50 50 Year 6 50 10% 19 05 6 6 05 05 6 $0 50 9 05 7 30 Year 7 $0 30 Year 8 50 50 30 50 501 20 Year 9 5 50 50 Year 10 50 50 50 50 50 50 50 61 FAS 50 50 50 50 50 7 7 2 $0 50 50 E H 05 Jos 05 05 2 8 $0 8 1 50 50 105 106 0$ B 50 50 so 50 50 9 50 50 50 50 50 05 50 05 10 $0 50 n $0 50 50 10 05 M 9 6 6 9 19 9 6 6 50 50 9 50 SO 50 sol 05 05 50 OS 90 05 2 50 50 50 50 N 10 $0 10 50 10 10 10 20 10 10 10 05 05 05 05 05 111 10 50 50 0 11 50 50 50 11 | 12 11 50 501 50 50 50 50 11 12 50 $0 $0 12 50 05 55 05 05 LLE 11 05 105 11 sol 50 12 112 50 50 50 11 35 05 05 05 50 12 $0 50 50 sol 50 50 50 50 30 50 12 12 12 50 50 50 12 50 50 05 50 35 50 50 E FIN 320 Project T...Financial Formulas Se Calibri A A C D 1 2 Rate of Return Year 3 Initial Investment Interest 4 Investment Value 5 6 Y 9 10 11 12 13 14 15 16 17) 18 39 B [] Home Insert Draw Formulas 12 9 B I US aA F K Time Value of Money-Annual Compounding 2 3 4 5 6 7 So $0 $0 $0 $0 $0 $0 $0 $0 $0 E 1 50 50 12 Data Y Review View L M 8 9 SO 50 SO $0 50 $0 N 10 So 50 Y 3 Calibri 14 fx Time Value of Money - Present Value Annuity B C D 1 Time Value of Money - Present Value Annuity Number of Years. Rate of Return Payment $0.00 234 5 67896 10 11 12 13 14 15 16 17 18282222: 19 20 23 24 DATION Monthle Annual PV BIUS aAv E FV PV-Lump Sum LL F Lo P G FV-Lump Sum H NPV M T C... Y Calibri 14 fx Time Value of Money - Future Value Annuity A B E Time Value of Money - Future Value Annuity 2 Number of Years 3 Rate of Return $0.00 4 Payment 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 DI 5 F LL aA > G > Calibri 14 BIUS aA - fx Time Value of Money - Present Value of Lump Sum A B C D E F H 1 Time Value of Money - Present Value of Lump Sum 2 Rate 3 Years $0.00 Initial Investment 4 S678 2: 5 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 OF RATIOS Monthly Annual PV LL fx Time Value of Money - Future Value of Lump Sum A B C D E 1 Time Value of Money - Future Value of Lump Sum 2 Rate 3 Years $0.00 4 Initial Investment 5 7 8 9 10 11 12 13 14 15 16 17 18 19 F fx Time Value of Money - Future Value of Lump Sum A B C D E 1 Time Value of Money - Future Value of Lump Sum 2 Rate 3 Years $0.00 4 Initial Investment 5 7 8 9 10 11 12 13 14 15 16 17 18 19 F S 4 initial Investment Amal Cash inflows Discount Rate Number of Years Salvage Velie initial investment Ciscount Rate Number of Tears Salvare Value S 40 al Investment Disnt Rate Number of Years Pincel Returned RATIOS Calibri Monthly C NPV- Annual 12 50 50 PV BIUS aA 2 M G H Net Present Value (NPV) Calculator Building Year 2 Cash Flows Year 12 Cash Flows Equipment Year 1 Cash Fis 11 Year Cash Flow FV Bonds Year Cash Flows 1 11 1 50 50 $0 2 12 sol PV-Lump Sum 50 50 50 $0 50 3 13 3 13. 50 50 50 4 14 4 14 4 50 50 sol M S 15 5 15 5 50 50 FVLump Sum 50 50 50 sol sel N 6 16 6 16 6 50 50 30 50 50 NPV 0 7 17 7 17 7 30 50 50 30 8 18 8 18 8 301 50 50 50 50 G 9 19 9 19 9 B 301 30 50 501 10 20 10 20 10 Se Arial fx McDonald's Corp (NYS: MCD) Exchange rate used is that of the Year End reported date As Reported Quarterly Balance Sheet Report Date 13 Currency 14 Audit Status 15 Consolidated 16 Scale 17 Cash & equivalents 18 Accounts & notes receivable 19 Inventories, at cost, not in excess of market 20 Prepaid expenses & other current assets 21 Total current assets 22 Investments in & advances to affliates 23 Goodwill 24 Miscellaneous 25 Total other assets 26 Lease right-of-use asset, net 27 Property & equipment, at cost 28 Accumulated depreciation & amortization 29 Net property & equipment 30 Total assets 31 Short-term borrowings 32 Accounts payable Lease ability 33 34 Dividends payable Income taxes 35 36 Other taxes 37 Accrued interest 38 Accrued payroll & other abilities 39 Current maturities of long-term debt 40 Total current liablities Long-term debit 42 Long-term lease liability 43 Long-term income taxes 44 Deferred revenues-initial tranchise fees Other long-term liabilites 45 Deferred income taxes 47 Common stock 46 Additional paid-in capital 49 Retained earnings (accumulated deficit) Accumulated other comprehensive income (loss) Common stock in treasury Total shareholders' equity (deficit) Balance sheet 4 5 6 7 a 10 11 12 $8253283848 50 55 56 03/31/2020 1st USD Unaudited Yes Thousand 5379800 1695300 39100 442700 7556900 1276800 2627400 2481400 6385600 13020600 38351500 14755600 23595900 50568000 1000000 671900 688600 234600 208900 308000 769800 106000 3987800 38046600 12470300 2158100 655000 893900 1649700 16600 7713500 53106700 2996400 67133800 0293400 Income statement 0 10 HE B Cash flow statement I G > Calibri 14 BIUS aA - fx Time Value of Money - Present Value of Lump Sum A B C D E F H 1 Time Value of Money - Present Value of Lump Sum 2 Rate 3 Years $0.00 Initial Investment 4 S678 2: 5 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 OF RATIOS Monthly Annual PV LL fx Time Value of Money - Future Value of Lump Sum A B C D E 1 Time Value of Money - Future Value of Lump Sum 2 Rate 3 Years $0.00 4 Initial Investment 5 7 8 9 10 11 12 13 14 15 16 17 18 19 F fx Time Value of Money - Future Value of Lump Sum A B C D E 1 Time Value of Money - Future Value of Lump Sum 2 Rate 3 Years $0.00 4 Initial Investment 5 7 8 9 10 11 12 13 14 15 16 17 18 19 F S 4 initial Investment Amal Cash inflows Discount Rate Number of Years Salvage Velie initial investment Ciscount Rate Number of Tears Salvare Value S 40 al Investment Disnt Rate Number of Years Pincel Returned RATIOS Calibri Monthly C NPV- Annual 12 50 50 PV BIUS aA 2 M G H Net Present Value (NPV) Calculator Building Year 2 Cash Flows Year 12 Cash Flows Equipment Year 1 Cash Fis 11 Year Cash Flow FV Bonds Year Cash Flows 1 11 1 50 50 $0 2 12 sol PV-Lump Sum 50 50 50 $0 50 3 13 3 13. 50 50 50 4 14 4 14 4 50 50 sol M S 15 5 15 5 50 50 FVLump Sum 50 50 50 sol sel N 6 16 6 16 6 50 50 30 50 50 NPV 0 7 17 7 17 7 30 50 50 30 8 18 8 18 8 301 50 50 50 50 G 9 19 9 19 9 B 301 30 50 501 10 20 10 20 10 Se Arial fx McDonald's Corp (NYS: MCD) Exchange rate used is that of the Year End reported date As Reported Quarterly Balance Sheet Report Date 13 Currency 14 Audit Status 15 Consolidated 16 Scale 17 Cash & equivalents 18 Accounts & notes receivable 19 Inventories, at cost, not in excess of market 20 Prepaid expenses & other current assets 21 Total current assets 22 Investments in & advances to affliates 23 Goodwill 24 Miscellaneous 25 Total other assets 26 Lease right-of-use asset, net 27 Property & equipment, at cost 28 Accumulated depreciation & amortization 29 Net property & equipment 30 Total assets 31 Short-term borrowings 32 Accounts payable Lease ability 33 34 Dividends payable Income taxes 35 36 Other taxes 37 Accrued interest 38 Accrued payroll & other abilities 39 Current maturities of long-term debt 40 Total current liablities Long-term debit 42 Long-term lease liability 43 Long-term income taxes 44 Deferred revenues-initial tranchise fees Other long-term liabilites 45 Deferred income taxes 47 Common stock 46 Additional paid-in capital 49 Retained earnings (accumulated deficit) Accumulated other comprehensive income (loss) Common stock in treasury Total shareholders' equity (deficit) Balance sheet 4 5 6 7 a 10 11 12 $8253283848 50 55 56 03/31/2020 1st USD Unaudited Yes Thousand 5379800 1695300 39100 442700 7556900 1276800 2627400 2481400 6385600 13020600 38351500 14755600 23595900 50568000 1000000 671900 688600 234600 208900 308000 769800 106000 3987800 38046600 12470300 2158100 655000 893900 1649700 16600 7713500 53106700 2996400 67133800 0293400 Income statement 0 10 HE B Cash flow statement I