The annuity is worth approximately $26,935.56. The project has a first IRR of approximately 7.46% with cash flows of -$800, $5,000, $200, and -$5,000 over four years at a cost of capital of 10%.
The explanation of the calculations for excel sheet is
Annuity Calculation
To calculate the present value of an annuity, we can use the formula:
PV = C * [(1 - (1 + r)⁻ⁿ) / r],
where PV is the present value, C is the cash flow per period, r is the interest rate per period, and n is the number of periods.
Using the given information:
C = $10,000 (cash flow per year),
r = 12% (interest rate), and
n = 20 (number of years).
Using the formula, we can calculate the present value (annuity worth) as follows:
PV = $10,000 * [(1 - (1 + 0.12)^(-20)) / 0.12]
PV ≈ $26935.56
Therefore, the annuity is worth approximately $26,935.56 today.
Internal Rate of Return (IRR) Calculation
To calculate the internal rate of return (IRR), we need to find the discount rate that makes the net present value (NPV) of the cash flows equal to zero. We can use the IRR function in Excel to find the IRR.
Using the cash flows given:
Year 0: -$800
Year 1: $5,000
Year 2: $200
Year 3: -$5,000
In Excel, you can use the following formula to calculate the IRR:
=IRR(B1:B4),
where B1:B4 represents the range of cash flows.
Using this formula, the first internal rate of return is approximately 7.46%.
Therefore, the first internal rate of return for the project is approximately 7.46%.
To know more about present value:
brainly.com/question/29586738
#SPJ4
Peyton Manufacturing is trying to decide between two different conveyor belt systems. System A costs $280,000, has a four-year life, and requires $85,000 in pretax annual operating costs. System B costs $396,000, has a six-year life, and requires $79,000 in pretax annual operating costs. Both systems are to be depreciated straight-line to zero over their lives and will have zero salvage value. Suppose the company always needs a conveyor belt system; when one wears out, it must be replaced. Assume the tax rate is 25 percent and the discount rate is 9 percent. Calculate the EAC for both conveyor belt systems. (Your answers should be negative values and indicated by minus signs. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
The EAC is the annual cost that would be equivalent to the costs incurred over the life of the system. To calculate the EAC (Equivalent Annual Cost) for each conveyor belt system, we need to determine the annual cash flows for each system and then calculate the present value of those cash flows.
For System A:
Initial Cost: -$280,000
Annual Operating Costs: -$85,000
Annual Cash Flow: -$85,000 (Operating Costs)
Depreciation Expense: -$280,000 / 4 = -$70,000
To calculate the tax savings from depreciation, we multiply the depreciation expense by the tax rate:
Tax Savings: $70,000 * 0.25 = -$17,500
Net Cash Flow (Year 0): -$280,000
Net Cash Flow (Years 1-4): -$85,000 - $17,500 = -$102,500
For System B:
Initial Cost: -$396,000
Annual Operating Costs: -$79,000
Annual Cash Flow: -$79,000 (Operating Costs)
Depreciation Expense: -$396,000 / 6 = -$66,000
Tax Savings: $66,000 * 0.25 = -$16,500
Net Cash Flow (Year 0): -$396,000
Net Cash Flow (Years 1-6): -$79,000 - $16,500 = -$95,500
Next, we calculate the present value of the net cash flows for each system using the discount rate of 9%.
For System A:
EAC_A = PV of Net Cash Flows / PVIFA(9%, 4)
EAC_A = [(-$280,000) + (-$102,500) / 0.09] / [1 - (1 / (1 + 0.09)^4)]
EAC_A = (-$382,500 / 0.3053) = -$1,252,955.14
For System B:
EAC_B = PV of Net Cash Flows / PVIFA(9%, 6)
EAC_B = [(-$396,000) + (-$95,500) / 0.09] / [1 - (1 / (1 + 0.09)^6)]
EAC_B = (-$491,500 / 0.4024) = -$1,221,512.40
Therefore, the EAC for System A is -$1,252,955.14 and for System B is -$1,221,512.40.
Learn more about EAC here:
https://brainly.com/question/32083814
#SPJ11
Earleton Manufacturing Company has $2 billion in sales and $471,500,000 in fixed assets. Currently, the company's fixed assets are operating at 85% of capacity.
What level of sales could Earleton have obtained if it had been operating at full capacity? Write out your answers completely. For example, 13 million should be entered as 13,000,000. Round your answer to the nearest dollar.
$
What is Earleton's target fixed assets/sales ratio? Do not round intermediate calculations. Round your answer to two decimal places.
%
If Earleton's sales increase 20%, how large of an increase in fixed assets will the company need to meet its target fixed assets/sales ratio? Write out your answer completely. Do not round intermediate calculations. Round your answer to the nearest dollar.
$
The Target fixed assets/sales ratio of Earleton's is 23.58% . The required increase in fixed assets is $242,454,000.
If Earleton Manufacturing Company is currently operating at 85% of capacity and has $2 billion in sales, to determine the level of sales it could have obtained if operating at full capacity, we can use the formula:
Full capacity sales = Current sales / Capacity utilization
Full capacity sales = $2,000,000,000 / 0.85 = $2,352,941,176 (rounded to the nearest dollar).
To calculate Earleton's target fixed assets/sales ratio, we divide the fixed assets by the sales and multiply by 100:
Target fixed assets/sales ratio = (Fixed assets / Sales) * 100
Target fixed assets/sales ratio = ($471,500,000 / $2,000,000,000) * 100 = 23.58% (rounded to two decimal places).
If Earleton's sales increase by 20%, we need to calculate the increase in fixed assets required to maintain the target fixed assets/sales ratio. First, we determine the new sales level:
New sales = Current sales + (Current sales * Sales increase)
New sales = $2,000,000,000 + ($2,000,000,000 * 0.20) = $2,400,000,000
Then, we calculate the required increase in fixed assets:
Required increase in fixed assets = (New sales * Target fixed assets/sales ratio) - Current fixed assets
Required increase in fixed assets = ($2,400,000,000 * 0.2358) - $471,500,000 = $242,454,000 (rounded to the nearest dollar).
Learn more about fixed assets link:
brainly.com/question/32409984
#SPJ11
