finance

profileh4919
FINMID1.xlsx
Home>Business & Finance homework help>Accounting homework help>finance

individual Report Example

Case. Blooper Industry 5year's project
10. Senario Analysis
1. Inputs Base Worst Best 6. Project Valuation & Investment Criteria Base Worst Best Final
Probabilities 50%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		20%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		30%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		Probabilities
Initial Investment ($) 10,000
Microsoft Office User: Microsoft Office User: a similar size of investment from a competitor or industry (with the citation on research and assumptions)
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		10,000 10,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		9,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		Disc. Payback Period
useful life of the invested assets (years) 5
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		5 5 5 Net Present Value
Salvage value of the fixed asset ($) 2,000
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		2,000 2,000 2,000 IRR
Sales of the fixed assets, t=5 ($) 3,000
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		3,000 2,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		3,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		PI
Selling price / unit (initial year) 15
Microsoft Office User: Microsoft Office User: reasonable expected sales price per unit, expected number of goods sold (with the citation on research and assumptions)
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		15 14
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		16
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Number of units sold a year 1,000
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		1,000 900
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		1,100
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Variable Cost (% of sales) 40%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		40% 45%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		35%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		7. BEP NPV Analysis
Initial fixed Cost ($) 4,000
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		4,000 4,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		3,500
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		Number of Units sold a year
Growth rate (Inflation included) 5%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		5% 5% 5% Selling price
Inflation 3%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		3% 3% 3% Variable Cost (%)
Discount rate (WACC) 12%
Microsoft Office User: Microsoft Office User: Industry average cost of capital (with the citation on research and assumptions) 		12% 13%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		12%
Accounts Receivable, as fraction of sales 17%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		17% 17% 17%
Inventory as fraction of following years' expenses 15%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		15% 15% 15% 8. Restricted 4 years DPP Analysis
Tax rate 35%
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		35% 35% 35% Discount rate (WACC)
Growth Rate
2. Capital Expenditure 0 1 2 3 4 5 Fixed Cost
Investment
Sales of fixed asset
Tax on gain of sale 9. Sensitivity Analysis
Cash flows in Capital Expenditure
Selling Price NPV
3. Operating cash flows 0 1 2 3 4 5 Deviation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		- 0 Deviation
Revenue
VC
FC
Depr.
EBIT Initial Investment NPV
Tax Deviation
Microsoft Office User: Microsoft Office User: assumptions and research with the citation 		- 0 Deviation
Depr.
Cash flows in Opr.
4. NOWC 0 1 2 3 4 5
NOWC
Cash flows of Changes in NOWC
5. Free Cash Flows 0 1 2 3 4 5 - 0
Free Cash Flows
PV of FCFs
Cumulative PV of FCFs