Build a forecasted balance sheet and income statement for 2015 using below. Use
ID: 2751142 • Letter: B
Question
Build a forecasted balance sheet and income statement for 2015 using below. Use 30% growth rate for sales sales. Assume AFN is going to be raised as 20% long term debt and 80% equity. Tax and dividend payout remain the same014 Tax Rate Dividends 20% 50% Interest Expense S&A; Expenses ccounts Payable Net Fixed Asset 48,09 571 New Equity Income Statements f0ce cal+ as %Yuan 2014 $406,427Y1 S2.8$ 214,607 2013 S 333,426 $ 169,969 33,425 S 47.980 S 82,052 Sales Cost of Goods Sold S&A; Expenses Depreciation EBIT Interest Expense EBT Taxes Net Income Dividends Addition to Retained Earnings 10.1$ 43,626 230 13.3 $ 54,23 $ 93.964 S 71,610 S 14.322 57,288 S 28,644 $82,010 Z0ES 16.402 S 65,608 S32,804 50 of Net in $28,644 S32,804
Explanation / Answer
forecasted income statement for 2015 ($)
sale (406427 + 30% * 406427) 528355
Cost of goods sold (214607/406427 *528355) 278989
S & A expense(43626 / 406427 * 528355) 56714
Depreciation 54230
EBIT 138422
Interest 11954
EBT 126468
TAX 25294
Net Income 101174
Dividend 50587
Retained Earning 50587
Note:- Depreciation is fixed expenses and continue to be same as in pevious year and interest expense will be same because no any debt is issued