50.1K

Verified Solution

Link Copied!

At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in the next five years. The board is considering $$5$ billion. Take the most recent financial statements and prepare a set of projected financial statements based on the given assumptions. The CEO requests that you prepare a written report $($including the financial statements$)$ for her. $\backslash$table$[[$All values USD Millions.,$2024],[$ST Debt & Current Portion LT Debt,$3,045],[$Short Term Debt,$1,929,],[$Current Portion of Long Term Debt,$1,116,],[$Accounts Payable,$10,498],[$Accounts Payable Growth,$-11\mathrm{.}69\%],[$Income Tax Payable,$],[$Other Current Liabilities,$5,761],[$Dividends Payable,$508],[$Accrued Payroll,$1,727,],[$Miscellaneous Current Liabilities,$3,526,],[$Total Current Liabilities,$19,304],[$Current Ratio,$0\mathrm{.}91],[$Quick Ratio,$0\mathrm{.}29],[$Cash Ratio,$0\mathrm{.}20],[$Long$-$Term Debt,$18,201],[$Long$-$Term Debt excl. Capitalized Leases,$13,028,],[$Non$-$Convertible Debt,$13,028,],[$Capitalized Lease Obligations,$1,894,],[$Provision for Risks & Charges,$33],[$Deferred Taxes,$2,480],[$Deferred Taxes $-$ Credit,$2,480],[$Other Liabilities,$1,906],[$Other Liabilities $($excl$.$ Deferred Income$),1,487],[$Deferred Income,$419],[$Total Liabilities,$41,924],[$Total Liabilities $/$ Total Assets,$75\mathrm{.}74\%],[$Common Equity $($Total$),13,432,],[$Common Stock Par$/$Carry Value,$38],[$Additional Paid$-$In Capital$/$Capital Surplus,$6,761],[$Retained Earnings,$7,093],[\backslash$table$[[$Cumulative Translation Adjustment$/$Unrealized$],[$For$.$ Exch. Gain$]],(24)],[$Other Appropriated Reserves,$(436)],[$Common Equity $/$ Total Assets,$24\mathrm{.}26\%],[$Total Shareholders' Equity,$13,432,],[$Total Shareholders' Equity $/$ Total Assets,$24\mathrm{.}26\%],[$Total Equity,$13,432,],[$Liabilities & Shareholders' Equity,$55,356]]$ Fiscal year is February$-$January. All values USD Millions.

$2024$

Sales$/$Revenue

$107,412$

Sales Growth

$-1\mathrm{.}57\%$

Cost of Goods Sold $($COGS$)$ incl. D&A

$80,151$

COGS excluding D&A

$77,350$

Depreciation & Amortization Expense

$2,801$

Depreciation

$2,800$

Amortization of Intangibles

COGS Growth

$1$

Gross Income

Gross Income Growth

Gross Profit Margin

SG&A Expense

$-5\mathrm{.}27\%$

Other SG&A

$27,261$

$11\mathrm{.}24\%$

SGA Growth

$25\mathrm{.}38\%$

EBIT

$21,452$

Unusual Expense

$21,452$

$4\mathrm{.}18\%$

Non Operating Income$/$Expense

Interest Expense

$5,809$

Interest Expense Growth

Gross Interest Expense

$78$

Pretax Income

$92$

Pretax Income Growth

$526$

Pretax Margin

$9\mathrm{.}13\%$

Income Tax

$526$

Income Tax $-$ Current Domestic

Income Tax $-$ Current Foreign

$5,297$

Income Tax $-$ Deferred Domestic

Income Tax $-$ Deferred Foreign

Consolidated Net Income

Net Income

$54\mathrm{.}97\%$

Net Income Growth

$4\mathrm{.}93\%$

Net Margin

$1,159$

$764$

$97$

$299$

Extraordinaries & Discontinued Operations

Discontinued Operations

Generate a projected income statement based on the given scenario.

Analyze the impact on the income statement based on the given scenario.

Generate a projected statement of retained earnings based on the given scenario.

Analyze the impact on the statement of retained earnings based on the given scenario.

Generate a projected balance sheet based on the given scenario.

Analyze the impact on the balance sheet based on the given scenario.

Generate a projected cash flow statement based on the given scenario.

Analyze the impact on the cash flow statement based on the given scenario.

Show all imagesShow all images

Answer & Explanation Solved by verified expert

See Answer