| Year | Particulars |
Present Value
Factor {1/((1+0.15)^year)} |
Amount ($) |
Present Value
($) (Amount * Present Value factor) |
| 0 | Initial Investment | 1.00 | (2,000,000) | (2,000,000.00) |
| 1 | Cash inflow | 0.87 | 200,000 | 173,913.04 |
| 2 | Cash inflow | 0.76 | 250,000 | 189,035.92 |
| 3 | Cash inflow | 0.66 | 300,000 | 197,254.87 |
| 4 | Cash inflow | 0.57 | 350,000 | 200,113.64 |
| 5 | Cash inflow | 0.50 | 400,000 | 198,870.69 |
| 6 | Cash inflow | 0.43 | 450,000 | 194,547.42 |
| 6 | Sale Value | 0.43 | 4,000,000 | 1,729,310.38 |
| 6 | Loan payment | 0.43 | (2,500,000) | (1,080,818.99) |
| 6 | Return of Initial Investment | 0.43 | 2,000,000 | 864,655.19 |
| NPV | 666,882.16 |
Since the NPV is positive hence the project should be accepted.
1. You consider building a project with a holding period of 6 years. Funds necessary to...
Chap 8-Net Present Value la. Amond Ltd has a payback period limit of three years and is considering investing in one of the following projects. Both projects require an initial investment of $800,000. Cash inflows accrue evenly throughout the year. Project Alpha Yeart Cash inflow 1 250,000 2 250,000 3 400,000 4 300,000 5 200,000 6 50,000 Project Beta Year Cash inflow 250,000 350,000 400,000 200,000 150,000 150,000 4 Company's cost of capital is 10%. Calculate the Payback period for...
Calculate the accounts receivable turnover, average collection
period (days), inventory turnover, fixed asset turnover, and total
asset turnover for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME...
Find the profit margin, ROA, and ROE for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS RETAINED EARNINGS 125,000 87,000 56,550 7,850 50,000 40,000 CASH ACCOUNTS...
You have 3 projects to consider. Project A with current and projected future rate of return Discount Factor at 17%. Yr Inflows Outflows Netflow Discounted netflow Discounted rate 0 -$450,000 -$450,000 -$450,000 1.0000 1 $150,000 $150,000 $128,205 0.8547 2 $150,000 $150,000 $109,577 0.7305 3 $150,000 $150,000 $93,656 0.6244 4 $150,000 $150,000 $80,048 0.5337 5 $150,000 $150,000 $68,417 0.4561 Project B with current and projected future rate of return Discount Factor 17% Yr Inflows Outflows Netflow Discounted netflow Discounted rate 0 -$400,000 -$400,000...
Your firm is considering a project with the following cash flows. The firm has a weighted average cost of capital of 6%. The firm usually accepts projects that payback in 4 years or less. Using what you know about payback period, which of the following statements is true about the firm's project selection? Year CF 0 -$2,000,000 1 $800,000 2 $600,000 3 -$200,000 4 $1,800,000 5 $400,000 6 $300,000 Year CF 0 $2,000,000 1 $800,000 2 $600,000 3 -$200,000 4...
Calculate the following for each of the years listed A. Debt/ Equity ratio B. Debt/asset ratio C.Profit Margin (as a %) D. Gross Margin (as a %) E. Calculate the change in profit margin over each year Exhibit 1: Iggy’s Financial Statements, 1994-1999 1994 1995 1996 1997 1998 1999 Income Statement Data Net revenue 1,000,000 2,500,000 3,000,000 4,000,000 4,500,000 6,000,000 Cost of goods sold Labor Other 570,000 220,000 350,000 1,700,000 900,000 800,000 1,920,000 1,080,000 840,000 2,520,000 1,480,000 1,040,000 3,195,000 1,890,000...
The answer is already given, I just don't understand how. Can
you please show how each value is caculated and label please!
2. Depreciation, taxes and source of finance. Compute the present value of a project with the following characteristics: Initial investment required 1 million dollars, 40% of it will be financed with a loan at 10% interest rate payable yearly in five years. Yearly savings for the first year of the project is $300,000, increasing by 50,000 year after...
s the opportunity to take over a 47. A company has the opportunity to redevelopment project in an industrial area o No immediate investment is required, but it must the existing buildings over a four-year period the end of the fourth year, invest $2,400,000 for new construction. It will collect all revenues and pay all costs for a period of 10 years, at which time the entire project, and properties thereon, will revert to the city. The net cash flows...
4.45. A company has the opportunity to take over a redevelopment project in an industrial area of a city. No immediate investment is required, but it must raze the existing buildings over a four- year period and at the end of the fourth year invest $2,400,000 for new construction. It will collect all revenues and pay all costs for a period of 10 years, at which time the entire project, and properties thereon, will revert to the city. The net...
6. Given the following, what is the after-tax cash flow? Assume No Cap. Ex and no principal payments Cost of goods 100 Depreciation and Amortization 35 Revenues 150 Selling, General, and Admin Exp 5 Tax rate 30% After cash flow = Use this data for the next two problems Sales $100.00 COGS 0.2 General and Admin $15.00 Depreciation $35.00 Interest Expense $35.00 Tax rate 0.25 7. Is the company profitable and by how much? (yes/ no) 8. Does the company...