Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please include excel formulas in the cells A. Complete a forecast for INTC, Intel Corp using percentage of sales approach if in the forecast year
Please include excel formulas in the cells
A. Complete a forecast for INTC, Intel Corp using percentage of sales approach if in the forecast year sales growth is expected to decrease by 10% (I.e. sales growth equal to -10%), taxes 21% and intel pays dividend using a dividend payout ratio of 20%. Generate pro-forma sheets, complete colums for titles highlighted in yellow. If you feel something (item or variable needs to be changed anywhere, you have the latitude to do so, just comment to let me know your intuition behind any such changes. B. In your forecast explain your decision in selecting any capital for EFN (if needed to make the sheet balanced. Explain implications towards other components of the financial documents and the company in general for the capital you select towards other components. Why would you choose that means over any other option? 2018 % af Skes 2018 ANSWERERAS Sales Growth Rate Taxes Dividend Payout Ratio Does NTC Need IN (AFN) in 2018 EAN (or EAN) Intel Corp (NMS: INTC) Standspied Ammusliname Statement 2017A % of Skess 2017 Total Revenue 62,761.00 Direct Costs 22.692.00 Gross Profit Selling General & Admin 7.474.00 Depreciation & Amortization 177.00 Research & Development 13,098.00 Restust Remediason & Impair 384.00 Other Operating Expense Total Indirect Operating costs Operating Income Interest Income (235.00) Gains on Sale of Assets 2,815.00 Other Non Operating income Total Non Operating Income Eamings Before Tax Taxation Equity Eatings Net Income Preference Dividends & Similar Net Income to Common Shares Outstanding Addition to Retained Eamings Come sould be 9,601 % of Sales 2017 2018 Adiusted BS Use this column to adjust the sheet and show where you adjust the sheet 2017A 3.433.0 10 5690 5,607.0 6,983.0 0.0 2008.0 100,395.0 59 2050 850.0 12.4040 37, 134.0 7140 8400 BALANCE SHEET ASSETS Cash & Equivalents Short Term investments Cash & Equips & ST Investments Receivables (ST) Inventores Current Tax Assets Assets Held for Sale (ST) Other Current Assets Total Curent Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Receivables (LT) Long Term investments Intangible Assets Prepayments (LT) Deted LT Assets Other Assets Total Fixed Assets Total Assets LABILMES & EQUITY Labilities Accounts Payable Accrued Expenses Accounts Payable & Accrued Exps Current Debt Other Current Liabilities Total Ourent Liabilites LT Debt & Leases Defemed LT Liabilites Minority interests Other Liabilites Total Liabilites Equity Temporary Equity Common Share Capital Retained Eamings Accum Other Comprehensive Income For CurTrans (8) Other Equity Total Equity Total Liabilites & Equity 1,776.0 1656.0 25.037.0 3,0460 0.0 7.860,0 856.0 26 074 0 42.083.0 A. Complete a forecast for INTC, Intel Corp using percentage of sales approach if in the forecast year sales growth is expected to decrease by 10% (I.e. sales growth equal to -10%), taxes 21% and intel pays dividend using a dividend payout ratio of 20%. Generate pro-forma sheets, complete colums for titles highlighted in yellow. If you feel something (item or variable needs to be changed anywhere, you have the latitude to do so, just comment to let me know your intuition behind any such changes. B. In your forecast explain your decision in selecting any capital for EFN (if needed to make the sheet balanced. Explain implications towards other components of the financial documents and the company in general for the capital you select towards other components. Why would you choose that means over any other option? 2018 % af Skes 2018 ANSWERERAS Sales Growth Rate Taxes Dividend Payout Ratio Does NTC Need IN (AFN) in 2018 EAN (or EAN) Intel Corp (NMS: INTC) Standspied Ammusliname Statement 2017A % of Skess 2017 Total Revenue 62,761.00 Direct Costs 22.692.00 Gross Profit Selling General & Admin 7.474.00 Depreciation & Amortization 177.00 Research & Development 13,098.00 Restust Remediason & Impair 384.00 Other Operating Expense Total Indirect Operating costs Operating Income Interest Income (235.00) Gains on Sale of Assets 2,815.00 Other Non Operating income Total Non Operating Income Eamings Before Tax Taxation Equity Eatings Net Income Preference Dividends & Similar Net Income to Common Shares Outstanding Addition to Retained Eamings Come sould be 9,601 % of Sales 2017 2018 Adiusted BS Use this column to adjust the sheet and show where you adjust the sheet 2017A 3.433.0 10 5690 5,607.0 6,983.0 0.0 2008.0 100,395.0 59 2050 850.0 12.4040 37, 134.0 7140 8400 BALANCE SHEET ASSETS Cash & Equivalents Short Term investments Cash & Equips & ST Investments Receivables (ST) Inventores Current Tax Assets Assets Held for Sale (ST) Other Current Assets Total Curent Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Receivables (LT) Long Term investments Intangible Assets Prepayments (LT) Deted LT Assets Other Assets Total Fixed Assets Total Assets LABILMES & EQUITY Labilities Accounts Payable Accrued Expenses Accounts Payable & Accrued Exps Current Debt Other Current Liabilities Total Ourent Liabilites LT Debt & Leases Defemed LT Liabilites Minority interests Other Liabilites Total Liabilites Equity Temporary Equity Common Share Capital Retained Eamings Accum Other Comprehensive Income For CurTrans (8) Other Equity Total Equity Total Liabilites & Equity 1,776.0 1656.0 25.037.0 3,0460 0.0 7.860,0 856.0 26 074 0 42.083.0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started