Answer To: Pelican Pharmacueticals XXXXXXXXXXQ1 2017 1 Sydney Graduate School of Management ACCT7012 Corporate...
Rochak answered on Aug 22 2022
Cash flow statement summary
Personcare Pharmaceuticals Ltd. 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Background Data $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Cost of new product $1,110,000
Building modifications (Installation cost) $82,000
Additional cost in wages $202,000
Inc in Inventory $182,000
Inc in Receivables $193,000
Raw Material Cost: New Product $420,000 $560,000 $700,000 $840,000 $960,000 $988,800 $1,018,464 $1,049,018 $1,080,488 $1,112,903
Raw Material Cost: Contract Manufacturing $67,500 $86,000 $103,250 $121,500 $133,000 $136,990 $141,100 $145,333 $149,693 $154,183
Lost Sales of Current Product $575,000 $780,000 $1,000,000 $1,020,000 $1,150,400 $1,184,912 $1,220,459 $1,257,073 $1,294,785 $1,333,629
Variable Cost Current Product $172,250 $232,500 $295,000 $306,400 $340,908 $351,135 $361,669 $372,519 $383,695 $395,206
Year End Recievable Balance $193,151 $254,795 $339,315 $399,452 $438,181 $451,326 $464,866 $478,812 $493,177 $507,972
Taxes $0
New Product + Contract Manufacturing Sales $1,750,000 $2,320,000 $2,890,000 $3,460,000 $4,010,000 $4,130,300 $4,254,209 $4,381,835 $4,513,290 $4,648,689
Required Rate of Return $0
Inc in factory wages $50,000 $51,500 $53,045 $54,636 $56,275 $57,963 $59,702 $61,493 $63,338 $65,238
Advertisement cost $390,000 $390,000 $300,000 $250,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000
Inc in variable factory...