Solve the question by Excel please. Thank you.

For Deere & Co. (stock symbol: DE), we assume this company is already operating at full capacity. Based on the financial information collected online (see the bottom of this tab sheet), solve to answer the following questions about DE. Questions: A. Assuming that DE's profit margin will fluctuate across years, thus you must apply the "Pro Forma Financial Statements" method to do the financial planning for the forthcoming full year of 2020. What shall be the amount of DE's additional funds needed (AFN) for Year 2020? Notes: The firm's "Short/Current LT Debt" (i.e., notes payable) and "Long Term Debt" are presumably subject to 1.485% and 3.750% annual interest rate, respectively, on the ending balances as of the end of Year 2019. B. Based on your AFN answer, DE is considering to fill the AFN deficit gap (if positive) by "raising 25% of AFN in Short/Current LT Debt, raising 25% of AFN in Long-Term Debt, and raising 50% of AFN in Common Stock". How will such AFN financing decisions, after being implemented, affect DE's current ratios, total debt ratios, profit margins, and retums on invested capital (ROICs) between Y2019 and Y2020? Use calculations to support your arguments. PS: Just in case your calculated AFN might turn out to be negative --- i.e., the firm has more funding than needed, thus you shall instead eliminate the AFN gap by "paying off 25% of AFN in Short/Current LT debt, paying off 25% of AFN in Long-Term debt, and repurchasing 50% of AFN in Common Stock". How will such AFN de-financing decisions, after being implemented, affect DE's current ratios, total debt ratios, profit margins, and ROICs between Y2019 and Y2020? Use calculations to support your arguments. Sales Growth Estimates Next Year DE - 18. 50% Annual Balance Sheet (values in 000's) 2019/11/3 $3,857,000 $581,000 $40, 341,000 $5, 975,000 $0 $50, 754, 000 $215,000 $13, 540,000 $2, 917,000 $1,380,000 $2,739,000 $1, 466,000 $73, 011, 000 Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounts Payable Short-Term Debt / Current Portion of Long-Term De Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity $10, 293, 000 $15, 105,000 $0 $25, 398,000 $30, 229,000 $5,953,000 $0 $4,000 $14, 000 $61, 584, 000 $4,642,000 $29, 852,000 ($17, 474, 000) $0 ($5, 607,000) $11, 413,000 $73, 011, 000 Annual Income Statement (values in 000's) 2019/11/3 $39, 258,000 $26, 792, 000 $12, 466,000 $1,783, 000 $5, 129,000 $0 Period Ending: Total Revenue Cost of Revenue Gross Profit Operating Expenses Research and Development Sales, General and Admin. Expenses Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders $5,554, 000 $0 $5, 554, 000 $1, 466,000 $4, 088, 000 $852,000 $21,000 ($4,000) $3,253,000 $3,253,000 $3,253,000 Annual Cash Flow Statement (values in 000's) Dividends Paid $943, 000 For Deere & Co. (stock symbol: DE), we assume this company is already operating at full capacity. Based on the financial information collected online (see the bottom of this tab sheet), solve to answer the following questions about DE. Questions: A. Assuming that DE's profit margin will fluctuate across years, thus you must apply the "Pro Forma Financial Statements" method to do the financial planning for the forthcoming full year of 2020. What shall be the amount of DE's additional funds needed (AFN) for Year 2020? Notes: The firm's "Short/Current LT Debt" (i.e., notes payable) and "Long Term Debt" are presumably subject to 1.485% and 3.750% annual interest rate, respectively, on the ending balances as of the end of Year 2019. B. Based on your AFN answer, DE is considering to fill the AFN deficit gap (if positive) by "raising 25% of AFN in Short/Current LT Debt, raising 25% of AFN in Long-Term Debt, and raising 50% of AFN in Common Stock". How will such AFN financing decisions, after being implemented, affect DE's current ratios, total debt ratios, profit margins, and retums on invested capital (ROICs) between Y2019 and Y2020? Use calculations to support your arguments. PS: Just in case your calculated AFN might turn out to be negative --- i.e., the firm has more funding than needed, thus you shall instead eliminate the AFN gap by "paying off 25% of AFN in Short/Current LT debt, paying off 25% of AFN in Long-Term debt, and repurchasing 50% of AFN in Common Stock". How will such AFN de-financing decisions, after being implemented, affect DE's current ratios, total debt ratios, profit margins, and ROICs between Y2019 and Y2020? Use calculations to support your arguments. Sales Growth Estimates Next Year DE - 18. 50% Annual Balance Sheet (values in 000's) 2019/11/3 $3,857,000 $581,000 $40, 341,000 $5, 975,000 $0 $50, 754, 000 $215,000 $13, 540,000 $2, 917,000 $1,380,000 $2,739,000 $1, 466,000 $73, 011, 000 Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounts Payable Short-Term Debt / Current Portion of Long-Term De Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity $10, 293, 000 $15, 105,000 $0 $25, 398,000 $30, 229,000 $5,953,000 $0 $4,000 $14, 000 $61, 584, 000 $4,642,000 $29, 852,000 ($17, 474, 000) $0 ($5, 607,000) $11, 413,000 $73, 011, 000 Annual Income Statement (values in 000's) 2019/11/3 $39, 258,000 $26, 792, 000 $12, 466,000 $1,783, 000 $5, 129,000 $0 Period Ending: Total Revenue Cost of Revenue Gross Profit Operating Expenses Research and Development Sales, General and Admin. Expenses Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders $5,554, 000 $0 $5, 554, 000 $1, 466,000 $4, 088, 000 $852,000 $21,000 ($4,000) $3,253,000 $3,253,000 $3,253,000 Annual Cash Flow Statement (values in 000's) Dividends Paid $943, 000