50.1K

Verified Solution

Link Copied!

Forecasting an I/S and B/S
A. Use "Percent of Sales " approach
B. Use the Trend function to forecast Sales
c. Provide an analysis of the statisitical significance of the model please show how to do the important formulas for excel

INCOME STATEMENT Year 2013 % of Sales 8995.10 9488.80 9893.00 5403.80 5784.90 6004.70 3591.30 3703.90 3888.30 Less: Cost of Goods Sold Gross Profit Other Operating Revenue Less: Operating Expenses Operating Income EBIT Less: Interest Expense Other Income (Expenses) 2606.40 2689.70 2820.40 984.90 1014.20 1067.90 23.20 Gain (Loss) Income before Taxes EBT Less:Taxes Related to Operations N.I. before Min. Ern. 919.20 921.40 1017.30 3400331.70 349.00 579.10 589.70 668.30 Gain (Loss) Net Income (Loss) 579,10589.70 673.30 BALANCE SHEET Year ASSETS Current Assets 254.30304.00 575.50 632.60 1693.50 1884.50 77.40 1567.201621.40 1807.10 446.00 1424.10 1373.80 215.2062.50 260.50 13.703.30 140.80 Gross Receivables Less: Allowance for Bad Debts Net Trade Reccivables Inventories Prepaid Expenses Other Current Assets Total Current Assets 359640 3625.30 4157.70 Long-Term Assets: Net Tangible (Fixed) Assets (other than corlslfu?tion id443H0ss) 1542.10 Construction in Progress Intangible Assets Other Nonoperating Assets Other Operating Assets Total Long-Term Assets Total Assets LIABILITIES AND EQUITY Current Liabilities: 448.30171.00 410.90 397.30 437.80 266.2078.20 233.00 2260.50 2194.30 2285.30 5856.90 5819.60 6443.00 543.80432.00 504.40 924.20 855.30 425.20 Accounts Payable Short Term Loans Current Maturity of L.t. Debt Other Current Liabilities 621.90 494.00 851 2140.00 1786.70 1836.20 Total Current Liabilities Long-Term Liabilities: Long-term Debt 470.30 435.90 625.90 Deferred Liabilities 110.30 02.20 141.60 Redeemable Preferred Total Long-term L Total Liabilities Shareholders' Equity Common Equity-incl. Ret. Ern Total Equity Total Liabilities and Equity 580.90538.40 767.80 2720.90 2325.10 2604.00 3136.00 3494.50 3839.00 3136.00 3494.50 3839,00 5856.90 5819.60 6443.00 INCOME STATEMENT Year 2013 % of Sales 8995.10 9488.80 9893.00 5403.80 5784.90 6004.70 3591.30 3703.90 3888.30 Less: Cost of Goods Sold Gross Profit Other Operating Revenue Less: Operating Expenses Operating Income EBIT Less: Interest Expense Other Income (Expenses) 2606.40 2689.70 2820.40 984.90 1014.20 1067.90 23.20 Gain (Loss) Income before Taxes EBT Less:Taxes Related to Operations N.I. before Min. Ern. 919.20 921.40 1017.30 3400331.70 349.00 579.10 589.70 668.30 Gain (Loss) Net Income (Loss) 579,10589.70 673.30 BALANCE SHEET Year ASSETS Current Assets 254.30304.00 575.50 632.60 1693.50 1884.50 77.40 1567.201621.40 1807.10 446.00 1424.10 1373.80 215.2062.50 260.50 13.703.30 140.80 Gross Receivables Less: Allowance for Bad Debts Net Trade Reccivables Inventories Prepaid Expenses Other Current Assets Total Current Assets 359640 3625.30 4157.70 Long-Term Assets: Net Tangible (Fixed) Assets (other than corlslfu?tion id443H0ss) 1542.10 Construction in Progress Intangible Assets Other Nonoperating Assets Other Operating Assets Total Long-Term Assets Total Assets LIABILITIES AND EQUITY Current Liabilities: 448.30171.00 410.90 397.30 437.80 266.2078.20 233.00 2260.50 2194.30 2285.30 5856.90 5819.60 6443.00 543.80432.00 504.40 924.20 855.30 425.20 Accounts Payable Short Term Loans Current Maturity of L.t. Debt Other Current Liabilities 621.90 494.00 851 2140.00 1786.70 1836.20 Total Current Liabilities Long-Term Liabilities: Long-term Debt 470.30 435.90 625.90 Deferred Liabilities 110.30 02.20 141.60 Redeemable Preferred Total Long-term L Total Liabilities Shareholders' Equity Common Equity-incl. Ret. Ern Total Equity Total Liabilities and Equity 580.90538.40 767.80 2720.90 2325.10 2604.00 3136.00 3494.50 3839.00 3136.00 3494.50 3839,00 5856.90 5819.60 6443.00

Answer & Explanation Solved by verified expert

See Answer