1) Create and income statement 2) Cash flow statement 3)


Question Description:

35

Hi Solver, please see attached doc. Bibi – Cse –ContentedMilkCow.xls 1) Create and income statement 2) Cash flow statement 3) Calculate appropriate criteria Contented Milk Cows, Inc. Data Block Investments Central Office information New Building Construction New Building Salvage- year 10 Land- year 0 Land – yer 10 Initial Training Operation cost – year 0 Operation cost -following years $350,000 $550,000 $125,000 $150,000 $350,000 $30,000 $96,000 Year New hire 1 New hire 2 New hire 3 Inventory in year 0 Inventory in following years $200,000 25% Regional Offices Count Rennovation each Annual cost of maintenance Annual cost of new technicians 0 1 $125,000 $0 $0 2 $125,000 $0 $0 3 $125,000 $100,000 $0 4 $125,000 $100,000 $0 5 $125,000 $100,000 $75,000 6 $125,000 $100,000 $75,000 7 $125,000 $100,000 $75,000 8 $125,000 $100,000 $75,000 9 $125,000 $100,000 $75,000 10 $125,000 $100,000 $75,000 1 10 2 15 3 25 4 40 5 40 6 40 7 40 8 40 9 40 10 40 20 $25,000 $12,000 $84,000 Revenue and COGS Revenue % increase Sales Quantity Price each Revenue from sales Purchase costs (% of sales) Installation cost (% of sales) Constants Income tax rate Capital gains rate MARR Contract duration Depreciation % $0 $0 $0 25% Year of sales 0 $290,000 60% 7.5% $200,000 20% annually 15% annually 10% annually 10 years Year 0 20 year MACRS $2,900,000 $1,740,000 $217,500 $4,350,000 $2,610,000 $326,250 $7,250,000 $4,350,000 $543,750 1 3.750% 2 7.219% 3 6.667% $11,600,000 $6,960,000 $870,000 4 6.177% $11,600,000 $6,960,000 $870,000 5 5.713% $11,600,000 $6,960,000 $870,000 6 5.285% $11,600,000 $6,960,000 $870,000 7 4.888% $11,600,000 $6,960,000 $870,000 8 4.522% $11,600,000 $6,960,000 $870,000 9 4.462% $11,600,000 $6,960,000 $870,000 10 4.461% Read more

Answer

35