You have a chance to invest in a shopping center. The total investment forthe purchase of the land and construction of the center is $10,000,000today. You have calculated the yearly net after tax cash flows fromoperations as follows:Year 1:$1,500,000Year 2:2,000,000Year 3:2,250,000Year 4:2,500,000Year 5:2,750,000At the end of year 5 you will sell the shopping center for $18,000,000 aftertaxes.Required: |+Use the provided Excel spreadsheet to calculate the present value of all theoperating after-tax cash flows and the total cash flows for the projectassuming you require an 20% R.O.I. Use the attached "PRESENT VALUETABLE" for your calculations: ATCFPVFNPVATCFYR1YR2YR3YR4YR5TOTALTOTAL CASH FLOWSNATCF FROM OPERATIONS:NATCF FROM SALE OF PROJ:TOTAL NATCF:LESS COST OF PROJECT:NET RETURN:333333333

Alright, let me to present the whole answer along with the calculations made using the provided…

Answered: You have a chance to invest in a…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 16EA: Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in...

See similar textbooks

Similar questions

b. Project B costs $5,000 and will generate after-tax cash inflows of $500 in year 1; $1,200 in year 2; $2,000 in year 3; $2,500 in year 4; and $2,000 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $5,000 and will generate net cash inflows of $2,500 before taxes each year for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 25% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) d. Project D costs $5,000 and will generate sales of $4,000 each year for 5 years. The cash expenditures will be $1,500 per year. The firm uses straight-line depreciation with an estimated salvage value of $500 and has a tax rate of 25%. (1) What is the accounting (book) rate of return based on the original investment?…
Answer each independent question, (a) through (e), below. a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $5,000 and will generate after-tax cash inflows of $500 in year 1; $1,200 in year 2; $2,000 in year 3; $2,500 in year 4; and $2,000 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $5,000 and will generate net cash inflows of $2,500 before taxes each year for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 25% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.)…
Answer each independent question, (a) through (e), below. a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $5,000 and will generate after-tax cash inflows of $500 in year 1; $1,200 in year 2; $2,000 in year 3; $2,500 in year 4; and $2,000 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $5,000 and will generate net cash inflows of $2,500 before taxes each year for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 25% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.)…
The following data are from an after-tax cash flow analysis in year 1 for anew MACRS 5-year property. How much money would be saved in year 1 if 100% bonus depreciation is used? Initial Investment = $180,000 Regular MACRS Depreciation Deduction in Year 1 = $36,000 Before-Tax-and-Loan Cash Flow = $280,000 Loan Principal Payment = $17,500 Interest on Loan = $5,650. a. $30,240 b. $75,600 c. $37,800 d. $36,000.
Answer each independent question, (a) through (e), below. a. Project A costs $8,000 and will generate annual after-tax net cash inflows of $3,000 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $8,000 and will generate after-tax cash inflows of $700 in year 1, $2,200 in year 2, $3,900 in year 3, $3,200 in year 4, and $3,900 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $8,000 and will generate net cash inflows of $3,250 before taxes for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 30% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) d.…
Answer each independent question, (a) through (e), below. a. Project A costs $10,000 and will generate annual after-tax net cash inflows of $3,700 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $10,000 and will generate after-tax cash inflows of $900 in year 1, $2,400 in year 2, $4,300 in year 3, $3,400 in year 4, and $4,300 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $10,000 and will generate net cash inflows of $4,750 before taxes for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 20% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) d.…
A project has the following net profit after tax set out below. The average book value of the assets in the project is 131,028. What is the accounting rate of return of this project? Enter your final answer in decimals to four decimal places (e.g., if your answer is 5.55%, then enter 0.0555). Year Net Profit After Tax 1 5,097 2 7,365 3 8,627 4 10,946
A neighborhood shopping center is expected to generate after-tax cash flow of $750,000 per year (at end of year) indefinitely. If an interested buyer has a cost of money of 13 %, how much will he be willing to pay for this shopping center? A $6.64 million B) $7.50 million $5.77 million D $2.21 million
You have been asked to estimate the market value of an income-producing property. The table below provides 5 years of projected cash flows for the property. Use the discounted cash flow approach to income valuation to calculate the market value. Assume that you sell the property at the end of year 5 and that the net proceeds from the sale are $5 million. Also assume that the discount rate is 10%. PGI EGI NOI Year 1 $4.18 million $750,000 $780,000 $811,200 $637,500 $663,000 $689,520 $318,750 $331,500 $344,760 $6.11 million $4.12 million Year 2 $4.40 million Year 3 Year 4 $843,648 $717,101 $358,550 Year 5 $877,394 $745,785 $372,892
I ONLY need The questions E1, E2 and E4 answered. Answer each independent question, (a) through (e), below. a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $5,000 and will generate after-tax cash inflows of $500 in year 1; $1,200 in year 2; $2,000 in year 3; $2,500 in year 4; and $2,000 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $5,000 and will generate net cash inflows of $2,500 before taxes each year for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 25% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout…
You have been offered the opportunity to invest in a project that will pay$3,509per year at the end of years one through three and$6,911per year at the end of years four and five. These cash flows will be placed in a saving account that pays11.95percent per year. What is the future value of this cash flow pattern at the end of year five? Round the answer to two decimal places. Your Answer:
You paid $725,000 for a duplex and financed 75% of the purchase price. Your forecasted cash flows for the property are listed below and you expect to sell the property for $740,000 at the end of year 5 and you owe $499,318.73 on the property. What is your expected internal rate of return? Cash flow - year 1 $16,000 Cash flow - year 2 $17,000 Cash flow - year 3 $16,000 Cash flow - year 4 $15,000 Cash flow - year 5 $18,000 Answer should be formatted as a percent with two decimal places.

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

International Financial Management

Finance

ISBN:

9780357130698

Author:

Madura

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

International Financial Management

Finance

ISBN:

9780357130698

Author:

Madura

Publisher:

Cengage

SEE MORE TEXTBOOKS