“best case and “worse” case scenarios.”

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

Don't use plagiarized sources. Get Your Custom Essay on
“best case and “worse” case scenarios.”
Just from $13/Page
Order Essay

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?

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY