In: Finance
Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land three weeks ago (the survey cost $45,000) and concluded the following:
Please provide the Free Cash Flow for each year of this project (times t=0 through t=4) and compute the project’s NPV.
(Enter the full dollar amount for each cash flow/NPV. Round your answer to the nearest dollar. For example, a cash flow of $273,610.68 would be entered as 273611. Negative values should be entered appropriately using the "-" symbol before the dollar amount.)
T = 0 Cash Flow:
T = 1 Cash Flow:
T = 2 Cash Flow:
T = 3 Cash Flow:
T = 4 Cash Flow:
Project NPV:
Working Notes:
EBITDA = Earnings Before Interest, Taxes, Depreciation and Amortization.
Depreciation = $100,000 / 4 = $25,000 (It will added back because it is not a cash expense)
After Tax Cash flow from sale of equipment = Sale price ( 1 - Tax Rate)
= $25,000 (1-0.35)
= $16,250
Discount Factor Formula:
Where,
i = discount rate
n = number of periods