Question

market premium 5.4

25P20 101 pdf - Adobe Acrobat Reader DC indow Help 5 Chapter 13 - The C.. Engineering-Econo... Interest Tables (Ind.. Excel Problem Set.. * calculations directly in the excer cells.) Question 4 (based on Chapter 12) Angola Superheros, Inc. is considering launching a production of a new superhero toy. The production and sales are expected to last 4 years. The project would require a new machine, with a cost of $1,000,000. The machine would be depreciated using the straight-line method over 8 years to zero value after year 8. After 4 years, at the end of the project, the machine is expected to be sold for $30,000. The company estimates that 40,000 toys would be sold annually, at a selling price of $20 per unit. The variable cost of producing each unit is estimated to be $5. In addition, the company will have to pay fixed costs equal to $35,000 each year. The relevant cost of capital is 14%, and the company faces a 25% marginal tax rate. a. Compute the project's cash flows in years 0-4, calculate the net present worth of the project and its internal rate of return, and determine whether the project should be accepted. Explain your answer. b. Run a Monte Carlo simulation, varying the variable cost per unit, the annual fixed cost, and the number of units sold. Assume that the variable cost per unit has a mean of $5 and standard deviation of $0.20, that the annual fixed cost has a mean of $35,000 and standard deviation of $2,000, and that the number of units sold annually has a mean of 40,000 and standard deviation of 1,500, and that all three variables follow normal distribution Compute the present worth of the project for 100 simulation runs. Based on the simulation results, compute the average net present worth and the threshold for the 5% of worst possible outcomes. Comment on the results, the uncertainty of the project's net present worth, and whether the project should be accepted c. Use the data table function to construct a table showing the net present worth of the project, while varying the selling price per unit and the cost of capital. Use the following selling prices in your table: 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, and 25. Use the following cost of capital in your table: 9%, 10%, 11%, 12%, 13%, 14%, 15%, 16%, 17%, 18%, and 19%. Comment on the sensitivity of the project's present worth to the cost of capital and the selling price per unit. Omastian K unsodan Chamber 123 ẽ 9 x 9 = = = = 0 a

Answer 1

I	Initial Cash flow :
	Cost of Machine Value				($1,000,000)
	Initial net working capital investment				$0
					---------------
	Net Cash Outflow				($1,000,000)
					---------------
II	Operating Cash Flow:
	Revenue	(40000*$20 per unit)			$800,000
	Less: Operating Expenses:
		Fixed expenses		$35,000
		Variable cost		$200,000
		(40000*$5)		---------------	($235,000)
					---------------
	Profit Before depreciation and Tax				$565,000
	Less: Depreciation				($257,500)
	(cost of project - salvage value)/ useful life
					---------------
	Profit Before Tax				$307,500
	Less: Tax rate @ 25%				($73,800)
					---------------
	Profit After Tax				$233,700
	Add : Depreciation				$257,500
					---------------
	Operating Cash Flow After Tax				$491,200
					---------------
	Terminal Cash Flow:
	Salvage value of project at the end				$30,000
Solution :	a) Calculation Of NPV:
	Year	Cash Flow	Return rate @ 14%	Discounted CF
	1	$491,200	0.877192982	$430,877.19
	2	$491,200	0.769467528	$377,962.45
	3	$491,200	0.674971516	$331,546.01
	4	$491,200	0.592080277	$290,829.83
	4	$30,000	0.592080277	$17,762.41
				-------------------
		Discounted Cash Inflow (DCIF)		$1,448,977.89
	Less :	Discounted Cash Outflow (DCOF)		($1,000,000.00)
				-------------------
		NPV		$448,977.89
				-------------------
	IRR :
	Year	Cash Flow	Return rate @ 32%	Discounted CF	Return rate @ 35%	Discounted CF
	1	$491,200	0.757575758	$372,121.21	0.740740741	$363,851.85
	2	$491,200	0.573921028	$281,910.01	0.548696845	$269,519.89
	3	$491,200	0.434788658	$213,568.19	0.406442107	$199,644.36
	4	$491,200	0.329385347	$161,794.08	0.301068228	$147,884.71
	4	$30,000	0.329385347	$9,881.56	0.301068228	$9,032.05
				$1,039,275.05		$989,932.87
		at 32%	DCF = $1039275.05
		at 35%	DCF = $989932.87
		at what rate DCF is $1000000 ?		3%	?
				49342.18	39275.05
					2.387919423
				IRR	32%+2.387919423
				IRR = 34.387919423