Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help with this, already paid 30$ and it was not completed correctly. If you choose to do this, please use excel formulas for irrpv
Need help with this, already paid 30$ and it was not completed correctly. If you choose to do this, please use excel formulas for irrpv and other values, so i can see where the answer is coming from . thank you
3. Assume a company that plans the construction of an amusement park called Dracula Park in the heart of Transylvania. The project requires the following costs: $1,000,000 in year 1 and $1,500,000 in year 2 for construction; $82,000 in year 3, increasing at a rate of 4.5% per year in years 4 to 10 as operating and maintenance costs; $20,000 in each of years 1 and 2, and $40,000 in each of years 3 to 10 for advertising. The park will be opened to the pub of tourists will grow at a rate of 5% per year. The price of an entrance ticket will be $25. a. Construct a table containing the outflows, the inflows, the net cash flow, and the discounted cash flows for years 1 to 10 Annual Cash Outflows (Fixed) Total Cash Inflows Annual Revenue Annual Cash Outflows (Flexible) Production Costs Total Periodic Cash Outflows (Every 5 yr) Renovations Employee Training Total b. Calculate the NPV and the IRR and decide if the project is profitable. Explain your answer carefully using both the NPV an c. Calculate the cash balances and the interest based cash balances. For both columns, highlight the maximum amount tied d. What is the payback period in the project? What is the interest-based payback period? What do they represent? e. Copy and paste your table 5 rows below. Now, assume that the project will be financed through the issuance of $2,500,00 cash flow table; the outflows, the inflows, and the net cash flow and discounted cash flow, to include the bonds. Assume the f. What are the NPV and IRR for the project with the bonds? Why the change? the heart of Transylvania. tenance costs; k will be opened to the public starting with year 3 and they estimate that 25,000 tourists will visit the park in each of years 3 and 4, after w cash flows for years 1 to 10 for the Dracula Park project. The discount rate is 12%. fully using both the NPV and the IRR. the maximum amount tied in the project during the ten years. do they represent? h the issuance of $2,500,000 in bonds with a coupon rate of 8%, paid annually until maturity in 9 years (at year 10). Redo the lude the bonds. Assume the bonds are sold at face value in year 1. each of years 3 and 4, after which the number ar 10). Redo theStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started