50.1K

Verified Solution

Link Copied!

Finance explanation

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 more accurate "Pro Forma Financial Statements" method to do the financial planning for the forthcoming full year of 2021. What shall be the amount of DE's additional funds needed (AFN) for Year 2021? Notes: The firm's "Short Current LT Debt" (i.e.. notes payable) and "Long Term Debt" are presumably subject to 0.60% and 2.80% annual interest rate, respectively. on the ending balances as of the end of Year 2020. 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 returns on invested capital (ROICs) between Y 2020 and Y2021? 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 Y2020 and Y2021? Use calculations to support your arguments. 35 DE Sales Growth Estimates Next Full Year 2021 36 20,90% 37 38 39 40 41 Annual Balance Sheet (values in 000's) 01/11/2020 42 43 44 45 $7.066.000 $641.000 $39.875.000 $4.999.000 $0 $52.581.000 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 $193.000 $13.115.000 $3.081.000 $1.327.000 $3.295.000 $1.499.000 $75.091.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 Debt 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 63 64 $10.736.000 $13.264.000 $0 $24.000.000 $32.734.000 $5.413.000 $0 $7.000 $0 $62.154.000 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 $4.895.000 $31.646.000 ($18.065.000) $0 ($5.539.000) $12.937.000 $75.091.000 80 Annual Income Statement (values in 000's) 01/11/2020 $35.540.000 $23.677.000 $11.863.000 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 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 $1.644.000 $5.089.000 $0 $0 $5.130.000 $0 $5.130.000 $1.247.000 $3.883.000 $1.082.000 ($48.000) ($2.000) $2.751.000 $2.751.000 $2.751.000 97 98 99 100 101 102 103 104 Annual Cash Flow Statement (values in 000's) 105 106 107 108 Dividends Paid $956.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 more accurate "Pro Forma Financial Statements" method to do the financial planning for the forthcoming full year of 2021. What shall be the amount of DE's additional funds needed (AFN) for Year 2021? Notes: The firm's "Short Current LT Debt" (i.e.. notes payable) and "Long Term Debt" are presumably subject to 0.60% and 2.80% annual interest rate, respectively. on the ending balances as of the end of Year 2020. 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 returns on invested capital (ROICs) between Y 2020 and Y2021? 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 Y2020 and Y2021? Use calculations to support your arguments. 35 DE Sales Growth Estimates Next Full Year 2021 36 20,90% 37 38 39 40 41 Annual Balance Sheet (values in 000's) 01/11/2020 42 43 44 45 $7.066.000 $641.000 $39.875.000 $4.999.000 $0 $52.581.000 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 $193.000 $13.115.000 $3.081.000 $1.327.000 $3.295.000 $1.499.000 $75.091.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 Debt 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 63 64 $10.736.000 $13.264.000 $0 $24.000.000 $32.734.000 $5.413.000 $0 $7.000 $0 $62.154.000 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 $4.895.000 $31.646.000 ($18.065.000) $0 ($5.539.000) $12.937.000 $75.091.000 80 Annual Income Statement (values in 000's) 01/11/2020 $35.540.000 $23.677.000 $11.863.000 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 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 $1.644.000 $5.089.000 $0 $0 $5.130.000 $0 $5.130.000 $1.247.000 $3.883.000 $1.082.000 ($48.000) ($2.000) $2.751.000 $2.751.000 $2.751.000 97 98 99 100 101 102 103 104 Annual Cash Flow Statement (values in 000's) 105 106 107 108 Dividends Paid $956.000

Answer & Explanation Solved by verified expert

See Answer