Please help with part B and 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 18,500 3,708 26, 889 13, 400 0.05 0.12 1/4 G. 2 835 Spreadsheet Nate Investment Salvage Initial rev Intial exp Inflation Disc rate AR Iny pct Tax rate b. Calculate Blooper's working capital in each year of its project. (Do not round Intermediate calculntions. Round your answers to the nearest whole dollar amount.) Answer is complete but not entirely correct. Working capita 5,048 9,000 2 3 4 9.932 10,420 10.951 0 c. What is the change in project NPV? (Do not found intermediate calculations Round your answers to the nearest whole dollar amount) Answer is complete but not entirely correct. from 54.220 11 15.120 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 18,500 3,708 26, 889 13, 400 0.05 0.12 1/4 G. 2 835 Spreadsheet Nate Investment Salvage Initial rev Intial exp Inflation Disc rate AR Iny pct Tax rate b. Calculate Blooper's working capital in each year of its project. (Do not round Intermediate calculntions. Round your answers to the nearest whole dollar amount.) Answer is complete but not entirely correct. Working capita 5,048 9,000 2 3 4 9.932 10,420 10.951 0 c. What is the change in project NPV? (Do not found intermediate calculations Round your answers to the nearest whole dollar amount) Answer is complete but not entirely correct. from 54.220 11 15.120