Please help me to conduct an NPV analysis (with a table) using the following information:

Alternative 2

1. Revenue Growth of 100% for the next 5 years in all the Revenue Segments

2. COGS increase of 20% in first 3 years and 10% in the remaining 2 years. COGS has been computed as a % of total sales and on that value the increase of 20% for first 3 years and 25% for the next 2 years has been assumed.

3. Since Capital Value and the depreciation value are missing the Repairs and Maintenance has been increased by 50% every year

4. Payroll Tax rate has been increased by 10% consistently over a period of 5 years. This is computed as a % of sales for 2015 and increased by 10% in value terms.

5. All other Expenses have been assumed to be the same % of sales as 2015.

6. For Computation purpose of NPV, Discount Rate of 10% has been taken.

Basis the above assumptions, the NPV comes to $422,950. Please refer the workings below. Excel can be shared if required.

The COGS in the below working has increased higher than the sales growth and hence the company is not profitable in the long run.

EXHIBIT 1: PROFIT AND LOSS STATEMENT (2013-20150 FORKED RIVER BREWING COMPANY FY 2013 Y 2014 FY 2015 PROFIT& Loss REVENUES S 4,146 13,206 15,099 Sales Non-Beer Beer 68,601 315,373 555,618 Sales S 1.520 S 6,584 13,680 Sales Deposits Sales General S 3,511 8,074 21,621 TOTAL REVENUE 77,779 343,238 606,018 Production Inventory 16,654 96,175 165,836 Purchases 709 1,749 (27 14,749 7,969 17,289 Freight Expense Other Expense TOTAL COGS 33,144 105,892 183,098 Gross Margin 44,635 237,345 422,920 Gross Margin 57% 69% 70% EXPENSES Accounting, Legal, and 4,593 1,849 7,435 Licensing Advertising and Promotions 13,104 13,739 18,378 Insurance 2,841 4,353 6,685 Payroll 67,844 135,007 4,660 10,234 Payroll Taxes Rent 13,022 21,463 35,265 16,121 29,396 24,515 Repair and Maintenance Utilities 3,960 8,763 14,673 8,698 22,926 46,891 Other General and Admin TOTAL OPERATING 62,339 174,993 299,084 EXPENSES NET PROFIT (17,703.57) 62,352.31 $123,836.08 NET PROFIT SALES -23%, 18% 20%