Please solve part C.
Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 20% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. See SPREADSHEET 9.1 in the eBook for the baseline project evaluation and resulting NPV assuming 15% inventory expense SPREADSHEET 9.1 Financial projections for Blooper's Magnoosium mine (dollar values in thousands) Inputs Initial Investment Salvage value Initial revenue Initial expenses Inflation rate Discount rate Acct receiv. as % of sales Inven. as % of expenses Tax rate 10,500 2,100 16,320 10,200 0.05 0.12 1/4 0.2 0.35 Spreadsheet Name Investment Salvage Initial rev Intial_exp Inflation Disc_rate A R Inv_pct Tax rate a. Would project NPV be higher or lower than that in the Blooper spreadsheet? higher lower b. Calculate Blooper's working capital in each year of its project. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Answer is complete and correct. Working Capital Year 2,040 6,222 6,533 6,860 7,203 4,959 4 6 c. What is the change in project NPV? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Answer is not complete The increases NPV from $4,223 to Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 20% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. See SPREADSHEET 9.1 in the eBook for the baseline project evaluation and resulting NPV assuming 15% inventory expense SPREADSHEET 9.1 Financial projections for Blooper's Magnoosium mine (dollar values in thousands) Inputs Initial Investment Salvage value Initial revenue Initial expenses Inflation rate Discount rate Acct receiv. as % of sales Inven. as % of expenses Tax rate 10,500 2,100 16,320 10,200 0.05 0.12 1/4 0.2 0.35 Spreadsheet Name Investment Salvage Initial rev Intial_exp Inflation Disc_rate A R Inv_pct Tax rate a. Would project NPV be higher or lower than that in the Blooper spreadsheet? higher lower b. Calculate Blooper's working capital in each year of its project. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Answer is complete and correct. Working Capital Year 2,040 6,222 6,533 6,860 7,203 4,959 4 6 c. What is the change in project NPV? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Answer is not complete The increases NPV from $4,223 to
