Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

***Please see attachment 1. Create a proforma Income Statement for the brewpub project by creating a proforma income statement. Use the “best case and “worse” case scenarios.” To do this, you will nee

***Please see attachment

1. Create a proforma Income Statement for the brewpub project by creating a proforma income statement. Use the “best case and “worse” case scenarios.” To do this, you will need to calculate the annual revenues and annual expenses for the 10-year project, any changes in net working capital, and any changes to capital expenditures. Describe all assumptions and calculations you used to arrive at the final free cash flows.

2. Calculate the NPV and IRR of the project given the information presented

using the “best case scenario.” Should Samantha and Grant go ahead with the brewpub investment? Why or why not?

3. What would be the impact on NPV and IRR if the “worst case scenario”occurs? Would this alter Grant and Samantha’s decision whether to invest in the brewpub? Describe how you found this result (also show inthe spreadsheet).

4. Suppose they are operating under the best case scenario and they decide that in year 5 they would like to do major renovations to the restaurant (a capital expense). They figure this will cost an additional $1,000,000 in year 5. Along with the renovations, they figure they could increase the price of the beer to $7 per pint and keep it at that price for the duration of the project. How do these changes impact NPV and IRR? Is it worth it for the pair to go forward with the renovations? Describe how you found this result (also show in the spreadsheet).

5. Would there be a significant impact to Samantha and Grant’s brewpub decision if there were a change in the cost of capital? Describe how you found this result (also show in the spreadsheet).

6. Are there any other issues that you think might influence the pair’s investment decision? What, if anything, have Samantha and Grant not considered in their capital budgeting analysis?

Show more
  • @
  • 7 orders completed
ANSWER

Tutor has posted answer for $10.00. See answer's preview

$10.00

*** ********

Click here to download attached files: 1.PNG
Click here to download attached files: 10.png
Click here to download attached files: 4.PNG
Click here to download attached files: 3.PNG
Click here to download attached files: 8.PNG
Click here to download attached files: 2.PNG
Click here to download attached files: 5.PNG
Click here to download attached files: New Microsoft Excel Worksheet.xlsx
Click here to download attached files: best case -renovation .xlsx
Click here to download attached files: worst case.xlsx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question