finance homework excel! due in 3 hours!!
zaina
FIN313HMWKCFFAStmntCF.xlsx
Example 1
| | | | Balance Sheet |
| | | | | 2014 | 2015 | | 2014 | 2015 |
| | | | Cash | $986,000 | $210,890 | A/P | $2,007,850 | $2,715,850 |
| | | | A/R | $2,145,900 | $2,829,050 | N/P | $2,345,600 | $2,745,680 |
| | | | Inventory | $1,908,765 | $2,845,670 | Other CL | $1,008,905 | $1,156,095 |
| | | | Other CA | $765,000 | $1,189,650 |
| | | | Total CA | $5,807,679 | $7,077,275 | Total CL | $5,364,369 | $6,619,640 |
| | | | Net FA | $4,564,350 | $5,100,875 | LT Debt | $3,860,980 | $4,256,700 |
| | | | | | | Equity | $1,146,680 | $1,301,810 |
| | | | Total Assets | $10,372,029 | $12,178,150 | Total Liab. & Equity | $10,372,029 | $12,178,150 |
| | | | | | | | | | | | Income Statement |
| | | | | | | | | | | | Revenues | $7,655,575 |
| | | | | | | | | | | | Cost of Goods Sold | ($5,434,245) |
| | | | | | | | | | | | Gross Profit | $2,221,330 |
| | | | | | | | | | | | Expenses | ($1,288,455) |
| | | | | | | | | | | | Depreciation | ($567,435) |
| | | | | | | | | | | | EBIT | $365,440 |
| | | | | | | | | | | | Interest Expense | ($106,890) |
| | | | | | | | | | | | Taxable Income | $258,550 |
| | | | | | | | | | | | Taxes (40%) | ($103,420) |
| | | | | | | | | | | | Net Income | $155,130 |
Example 2
| | Balance Sheet |
| | | 2014 | 2015 | | 2014 | 2015 |
| | Cash | $234,560 | $87,051 | A/P | $6,527,890 | $8,875,582 | ($147,509) |
| | A/R | $5,678,910 | $7,137,865 | N/P | $2,680,323 | $4,374,183 |
| | Inventory | $7,098,765 | $9,865,425 | Other CL | $2,240,822 | $3,535,667 |
| | Other CA | $1,234,569 | $2,645,657 |
| | Total CA | $14,248,818 | $19,738,013 | Total CL | $11,451,049 | $16,787,447 |
| | Net FA | $8,127,898 | $11,167,654 | LT Debt | $7,578,987 | $9,925,129 |
| | | | | Equity | $3,346,680 | $4,193,091 | $846,411 |
| | Total Assets | $22,376,716 | $30,905,667 | Total Liab. & Equity | $22,376,716 | $30,905,667 |
| | Income Statement | 2015 |
| | Revenues | $33,456,710 |
| | Cost of Goods Sold | ($26,034,245) |
| | Gross Profit | $7,422,465 |
| | Expenses | ($3,988,455) |
| | Depreciation | ($1,267,435) |
| | EBIT | $2,166,575 |
| | Interest Expense | ($755,890) |
| | Taxable Income | $1,410,685 |
| | Taxes (40%) | ($564,274) |
| | Net Income | $846,411 |
| | | | | | | | | | | $0 |
