case 1

profileworkprovider1
case1stu.xlsx
Home>Business & Finance homework help>Accounting homework help>case 1

Sheet1

Albatross 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
BOAT $780,000
REBUILD $2,300,000
RECYCL $920,000 $8,100,000
INCIN $1,300,000
DESAL $2,800,000
GRANT -$1,800,000
NWC $275,000 -275000
OPP MARKET VALUE $0
REPLACED -$28,000
SALAGE $0
REVENUE PLASTIC $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000 $2,250,000
RESEARCH $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
MOVIE $3,000,000
GARBAGE $7,000
VARIABLE COST -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000 -$225,000
WAGES W FRINGE -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000 -$1,040,000
OTHER FIXED -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000 -$600,000
DEPR -$810,000 -$1,458,000 -$1,134,000 -$972,000 -$729,000 -$567,000 -$567,000 -$567,000 -$567,000 -$486,000 -$243,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
NPBT $2,682,000 -$973,000 -$649,000 -$487,000 -$244,000 -$82,000 -$82,000 -$82,000 -$82,000 -$1,000 $242,000 $485,000 $485,000 $485,000 $485,000 $485,000 $485,000 $485,000 $485,000 $485,000
TAX $804,600 -$291,900 -$194,700 -$146,100 -$73,200 -$24,600 -$24,600 -$24,600 -$24,600 -$300 $72,600 $145,500 $145,500 $145,500 $145,500 $145,500 $145,500 $145,500 $145,500 $145,500
NPAT $1,877,400 -$681,100 -$454,300 -$340,900 -$170,800 -$57,400 -$57,400 -$57,400 -$57,400 -$700 $169,400 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500
EXTERNALITY 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CBCF -$6,547,000 $2,687,400 $776,900 $679,700 $631,100 $558,200 $509,600 $509,600 $509,600 $509,600 $485,300 $412,400 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $339,500 $614,500
Goat 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
FARM $1,100,000
EQUIP $100,000
NWC $400,000 0
OPP MARKET VALUE $380
REPLACED
SALVAGE $1,675,000
REVENUE CHEESE $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000 $580,000
REVENUE GOATS $0 $0 $0 $0 $0 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
VARCHEESE -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000 -$200,000
VARGOATS $0 $0 $0 $0 $0 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000 -$10,000
FIXED -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000 -$180,000
DEPR -$20,000 -$32,000 -$19,000 -$12,000 -$11,000 -$6,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
NPBT $180,000 $168,000 $181,000 $188,000 $189,000 $244,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000
TAX $54,000 $50,400 $54,300 $56,400 $56,700 $73,200 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000
NPAT $126,000 $117,600 $126,700 $131,600 $132,300 $170,800 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000
EXTERNALITY $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
CBCF -$1,600,380 $146,700 $150,300 $146,400 $144,300 $144,000 $177,500 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $175,700 $1,850,700

Sheet2

Sheet3