Complete the Old Turkey Mash case including original financial statementwith advertising(see below),revised financial statement, and a discussion of which financial statement to submit to the bank and why? (please be brief).
\f Solution-a Revenues Less:Cost of Goods Sold (bbls distilled @ $100/bbl) Oak barrels Warehouse rental Cost of advertising Warehouse direct costs Net Income before taxes Income taxes (30%) Net Income after taxes Increase in income from capitalizing aging costs Base Year Year 1 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $0 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $185,500 Year 3 Year 4 $6,000,000 $1,000,000 1,200,000 $1,240,000 $3,100,000 $25,000 ($565,000) $169,500 ($395,500) $6,000,000 $1,000,000 1,350,000 $1,400,000 $3,500,000 $25,000 ($1,275,000) $382,500 ($892,500) Solution-b Revenues Less: Cost of Goods Sold (Gallons sold*$2.50) Oak barrels Warehouse rental Warehouse direct costs Cost of advertising Net Income before taxes Income taxes (30%) Net Income after taxes Year 2 Year 3 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $486,500 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $885,500 Year 5 Year 6 $6,000,000 $1,000,000 1,500,000 $1,600,000 $4,000,000 $25,000 ($2,125,000) $637,500 ($1,487,500) Cost of Advertising Year 7 Year 8 $7,200,000 $8,400,000 $9,600,000 $1,200,000 $1,400,000 $1,600,000 1,500,000 1,500,000 1,500,000 $1,760,000 $1,880,000 $1,960,000 $4,400,000 $4,700,000 $4,900,000 $25,000 $25,000 $25,000 ($1,685,000) ($1,105,000) ($385,000) $505,500 $331,500 $115,500 ($1,179,500) ($773,500) ($269,500) Year 9 Year 10 $10,800,000 $1,800,000 1,500,000 $2,000,000 $5,000,000 $25,000 $475,000 $142,500 $332,500 $12,000,000 $2,000,000 1,500,000 $2,000,000 $5,000,000 $25,000 $1,475,000 $442,500 $1,917,500 Cost of Advertising Warehouse direct costs Cost of Advertising Warehouse direct costs Solution-a Revenues Less:Cost of Goods Sold (bbls distilled @ $100/bbl) Oak barrels Warehouse rental Cost of advertising Warehouse direct costs Net Income before taxes Income taxes (30%) Net Income after taxes Increase in income from capitalizing aging costs Base Year Year 1 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $0 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $185,500 Year 3 Year 4 $6,000,000 $1,000,000 1,200,000 $1,240,000 $3,100,000 $25,000 ($565,000) $169,500 ($395,500) $6,000,000 $1,000,000 1,350,000 $1,400,000 $3,500,000 $25,000 ($1,275,000) $382,500 ($892,500) Solution-b Revenues Less: Cost of Goods Sold (Gallons sold*$2.50) Oak barrels Warehouse rental Warehouse direct costs Cost of advertising Net Income before taxes Income taxes (30%) Net Income after taxes Year 2 Year 3 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $486,500 $6,000,000 $1,000,000 750,000 $1,000,000 $25,000 $2,500,000 $725,000 $217,500 $507,500 $885,500 Year 5 Year 6 $6,000,000 $1,000,000 1,500,000 $1,600,000 $4,000,000 $25,000 ($2,125,000) $637,500 ($1,487,500) Cost of Advertising Year 7 Year 8 $7,200,000 $8,400,000 $9,600,000 $1,200,000 $1,400,000 $1,600,000 1,500,000 1,500,000 1,500,000 $1,760,000 $1,880,000 $1,960,000 $4,400,000 $4,700,000 $4,900,000 $25,000 $25,000 $25,000 ($1,685,000) ($1,105,000) ($385,000) $505,500 $331,500 $115,500 ($1,179,500) ($773,500) ($269,500) Year 9 Year 10 $10,800,000 $1,800,000 1,500,000 $2,000,000 $5,000,000 $25,000 $475,000 $142,500 $332,500 $12,000,000 $2,000,000 1,500,000 $2,000,000 $5,000,000 $25,000 $1,475,000 $442,500 $1,917,500 Cost of Advertising Warehouse direct costs Cost of Advertising Warehouse direct costs