Calculate the NPV by calculating all months given in first pic . please do it as soon as possible. thnks

NETWORK PROBLEMS We're having trouble verifying your Office Subscription status due to a network or temporary IVICE Welkeep trying You an keep using Belut Saturday, July 11, 2021 Le H M N 0 P Capstick Muffler 12-Month Cash Flow Period Beginning Period Ending Cash at Beginning of Period Cash at End of Pened 1/1/20 7/21 6/1/91 7/1/51 191 91/91 10/1/91 11/11 1271/91 1/1/12 2/12 11/20 4/1/20 0 0 0 0 0 0 Jan 20 Jun"91 Jul91 Aug 91 Sep'91 Oct1 Nov'91 Dec'91 Jan's2 Feb'92 Mar 20 Apr 20 Operations Cash receipts from Customers Other operations Cash and for Inventory purchases General operating and Advertisement Wages Depreciation Income Net Cash Flow from Operations Insert Ted Bo Below 0 0 0 0 0 0 0 00 0 0 What is the Minimum Price you would be willing to pay for this businesfassume the 12 months are the only the this space for your NPV Clinton Aumes out of rededoc Statement Expenditure Report H Exhibit 1 2 4 B $230,769 87 692 $143,077 10 11 12 13 14 TS 16 17 Capstick Muffler Limited Projected Income Statement For Year Ended April 30, 1991 Sales (219,780 1.05) Cost of Mufflers Sold Gross Profit Expenses Accounting & Legal Advertising & Promotion Insurance Interest & Bank Charges Miscellaneous Welding Supplies Civic Taxes Utilities Vehicle Wages & Benefits Net Income before Depreciation Depreciation Net Income before Income Taxes Income Taxes Net Income 70 19 $1,575 12,600 4.200 15.701 263 9,231 1,050 6,300 2.100 57645 110 665 32,412 5.400 27.012 5.943 $21.069 30 12 MonthCashFlow Projected Financial Statement Expenditure Report G38 X fo 6.2 73 Percentage of Yearly Sales by Month Month Month % Month % May 11.6 September 7.3 January June 11.9 October 6.5 February 73 July 9.2 November March 8.8 August 9.7 December 42 April 10.0 Source: Company Records Finally, in forecasting his new facility's first-year sales, Capstick projected a 5% inflation rate base, Increase in prices to take effect on May 1st Capstick felt that general inflation-rate- induced increases in costs could be passed on through corresponding increases in sales prices 11 Projected Cash Expenditures Capstick based his expense projections for the year (see Exhibit 1) on (1) his previous years experience with adjustments where necessary for increased costs due to the new larger shop. (2) his in-town location, (3) his use of debt financing to establish this new shop. (4) the 31 implementation of a new promotion strategy and (5) the current inflation rate. Production supplies were a major expense for the muffler shop the cost of mufflers was 38% of sales and the cost of welding supplies was 4% of sales. Although the cost of mufflers could 20 a vary somewhat Capstick expected no change in the percentage cost of welding supplies. The mufflers and welding supplies were purchased on 30-day terms in the month preceding the sale Wages, also a major expense, were paid out equally over the year Another major expense was the financing charges on the $121.500 bank loan being negotiated by Capstick to finance the new shop interest and bank charges were to be paid monthly with interest calculated on the outstanding loan balance at a Boating rate of interest 35 of prime (currently 125) plus 1% A51012 50 principal payment on the loan was also payable monthly Bank charges were estimated to be $50 per month (net inflation) Capstick's new promotion strategy was also expected to result in substantial cash expenditures. To launch this new muffler Shop Caps tended to spend about 20% of his yearly advertising budget in April on Opening Soon gosind 30 May or Now Oper messages. They up front expendit so intended to impress Capstick's quality and accessibility on the marketing start of the peakon porod. The remainder of the advertising budget was being sente over the remaining months to Sustain customer nessels Aigare se den 10-day terms 51 Capstoks depreciation expense weeds to be 1500 because of con of The capsustees with exception of income taxespected to be padrove the may be copied Spit od nas to pay como focalyand mastodidesharement in cash for 16 11 11 41 1 1 ST 12 MonthEaston projected Financial Statement x NETWORK PROBLEMS We're having trouble verifying your Office Subscription status due to a network or temporary IVICE Welkeep trying You an keep using Belut Saturday, July 11, 2021 Le H M N 0 P Capstick Muffler 12-Month Cash Flow Period Beginning Period Ending Cash at Beginning of Period Cash at End of Pened 1/1/20 7/21 6/1/91 7/1/51 191 91/91 10/1/91 11/11 1271/91 1/1/12 2/12 11/20 4/1/20 0 0 0 0 0 0 Jan 20 Jun"91 Jul91 Aug 91 Sep'91 Oct1 Nov'91 Dec'91 Jan's2 Feb'92 Mar 20 Apr 20 Operations Cash receipts from Customers Other operations Cash and for Inventory purchases General operating and Advertisement Wages Depreciation Income Net Cash Flow from Operations Insert Ted Bo Below 0 0 0 0 0 0 0 00 0 0 What is the Minimum Price you would be willing to pay for this businesfassume the 12 months are the only the this space for your NPV Clinton Aumes out of rededoc Statement Expenditure Report H Exhibit 1 2 4 B $230,769 87 692 $143,077 10 11 12 13 14 TS 16 17 Capstick Muffler Limited Projected Income Statement For Year Ended April 30, 1991 Sales (219,780 1.05) Cost of Mufflers Sold Gross Profit Expenses Accounting & Legal Advertising & Promotion Insurance Interest & Bank Charges Miscellaneous Welding Supplies Civic Taxes Utilities Vehicle Wages & Benefits Net Income before Depreciation Depreciation Net Income before Income Taxes Income Taxes Net Income 70 19 $1,575 12,600 4.200 15.701 263 9,231 1,050 6,300 2.100 57645 110 665 32,412 5.400 27.012 5.943 $21.069 30 12 MonthCashFlow Projected Financial Statement Expenditure Report G38 X fo 6.2 73 Percentage of Yearly Sales by Month Month Month % Month % May 11.6 September 7.3 January June 11.9 October 6.5 February 73 July 9.2 November March 8.8 August 9.7 December 42 April 10.0 Source: Company Records Finally, in forecasting his new facility's first-year sales, Capstick projected a 5% inflation rate base, Increase in prices to take effect on May 1st Capstick felt that general inflation-rate- induced increases in costs could be passed on through corresponding increases in sales prices 11 Projected Cash Expenditures Capstick based his expense projections for the year (see Exhibit 1) on (1) his previous years experience with adjustments where necessary for increased costs due to the new larger shop. (2) his in-town location, (3) his use of debt financing to establish this new shop. (4) the 31 implementation of a new promotion strategy and (5) the current inflation rate. Production supplies were a major expense for the muffler shop the cost of mufflers was 38% of sales and the cost of welding supplies was 4% of sales. Although the cost of mufflers could 20 a vary somewhat Capstick expected no change in the percentage cost of welding supplies. The mufflers and welding supplies were purchased on 30-day terms in the month preceding the sale Wages, also a major expense, were paid out equally over the year Another major expense was the financing charges on the $121.500 bank loan being negotiated by Capstick to finance the new shop interest and bank charges were to be paid monthly with interest calculated on the outstanding loan balance at a Boating rate of interest 35 of prime (currently 125) plus 1% A51012 50 principal payment on the loan was also payable monthly Bank charges were estimated to be $50 per month (net inflation) Capstick's new promotion strategy was also expected to result in substantial cash expenditures. To launch this new muffler Shop Caps tended to spend about 20% of his yearly advertising budget in April on Opening Soon gosind 30 May or Now Oper messages. They up front expendit so intended to impress Capstick's quality and accessibility on the marketing start of the peakon porod. The remainder of the advertising budget was being sente over the remaining months to Sustain customer nessels Aigare se den 10-day terms 51 Capstoks depreciation expense weeds to be 1500 because of con of The capsustees with exception of income taxespected to be padrove the may be copied Spit od nas to pay como focalyand mastodidesharement in cash for 16 11 11 41 1 1 ST 12 MonthEaston projected Financial Statement x