Spreadsheet: 145705d1331719402-autofill-across-worksheets-indirect
Sheet: Income Statement

 |  |  |  | INCOME STATEMENT
 |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
Gross Sales Revenue | 48263.22207903377 | 51236.59616323787 | 44711.52716623095 | 54471.00649758161 | 52051.79684753756 | 49251.97733994215 | 79047.46079666849 | 87373.59734288839 | 85327.51834003757 | 123809.2325196436 | 171057.9453417051 | 194420
Beginning Inventory | 8594.326341099566 | 8810.949416829415 | 708.7276709988926 | 0 | 92.3907798618545 | 16001.2305957588 | 0 | 11439.05953912347 | 23067.30195848739 | 35050.97443380066 | 39189.74874606584 | 37291
Total Production Cost | 32669.2802548182 | 29486.31123413487 | 31565.43670996807 | 36485.65576681526 | 45003.39210407129 | 31768.7250693106 | 46848.79653435509 | 45180.77538764689 | 40734.86403331205 | 40883.02353598315 | 45337.18513856729 | 37546
Goods Available | 41263.60659591777 | 38297.26065096429 | 32274.16438096696 | 36485.65576681526 | 45095.78288393314 | 47769.9556650694 | 46848.79653435509 | 56619.83492677035 | 63802.16599179944 | 75933.99796978381 | 84526.93388463312 | 74837
Ending Inventory | 8810.950496743597 | 732.2872699138002 | 0 | 92.39062957992232 | 16001.23095971479 | 0 | 11439.05993330615 | 23065.46892723707 | 35048.21234453439 | 39188.65575986839 | 37305.47921751373 | 22911
Market 1 |  |  | 0 |  |  | 0
Market 2 |  |  | 0 |  |  | 0
Market 3 |  |  | 0 |  |  | 0
Cost of Goods Sold | 32452.65609917418 | 37564.97338105048 | 32274.16438096696 | 36393.26513723534 | 29094.55192421835 | 47769.9556650694 | 35409.73660104893 | 33554.36599953328 | 28753.95364726505 | 36745.34220991543 | 47221.45466711939 | 51926
Gross Profit
Marketing Cost | 5451.873823450331 | 5894.512506245432 | 5916.690150229446 | 7198.438230355378 | 8499.721413899746 | 9653.875775124328 | 11467.83649550702 | 12179.32995774063 | 11828.72988270592 | 15579.63561862309 | 19575.13895063947 | 21077
Profit on Sales | 10358.69215640927 | 7777.110275941952 | 6520.672635034538 | 10879.30312999089 | 14457.52350941946 | -8171.854100251574 | 32169.88770011253 | 41639.90138561447 | 44744.83481006659 | 71484.25469110506 | 104261.3517239462 | 121418
Other Costs | 5802.496652600044 | 6378.134628538357 | 6091.161259178189 | 7008.534374272705 | 7333.643258098889 | 7643.816930882104 | 8764.857519971334 | 9594.546273835653 | 10015.95546791917 | 12785.65743969297 | 15374.71503798919 | 16711
Other Income | 410.6 | 280 | 220 | 260 | 300 | 340 | 420 | 420 | 420 | 540.6 | 420 | 801
Net Profit Before Taxes
Income Tax | 2483.397751904612 | 839.4878237017974 | 324.7556879281747 | 2065.384377859094 | 3711.940125660286 | 0 | 11912.5150900706 | 16232.67755588941 | 17574.43967107371 | 29619.59862570605 | 44653.31834297851 | 52754
Profit Sharing Cost | 10 | 6 | 3 | 77 | 186 | 0 | 668 | 846 | 916 | 1614.268125100979 | 2612.219123064244 | 3244
Net Income | 2473.464160896994 | 833.1916650240339 | 321.5081310488929 | 1987.932463689378 | 3525.971925364705 | -15475.67103113368 | 11244.22299351763 | 15386.95505522757 | 16658.81136421077 | 28005.33050060507 | 42041.09921991429 | 49510
Dividends Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]