Question
Suppose that Bloopers customers paid their bills with an average 3-month delay (instead of 2 months) and that Bloopers inventories were 15% rather than 15%
Suppose that Bloopers customers paid their bills with an average 3-month delay (instead of 2 months) and that Bloopers inventories were 15% rather than 15% of next years 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 Spreadsheet Name Initial Investment 150 Investment Salvage value 20 Salvage Initial revenue 172 Initial_revenue Initial expenses 122 Intial_expenses Inflation rate 0.05 Inflation Discount rate 0.12 Discount_rate Acct receivable as % of sales 1/4 A_R Investment as % of expenses 0.1 Inv_pct Tax rate 0.21 Tax_rate Would project NPV be higher or lower than that in the Blooper spreadsheet? Calculate Bloopers working capital in each year of its project. What is the change in project NPV?
Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 15% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. 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) a. Would project NPV be higher or lower than that in the Blooper spreadsheet? b. Calculate Blooper's working capital in each year of its project. c. What is the change in project NPV? Complete this question by entering your answers in the tabs below. Would project NPV be higher or lower than that in the Blooper spreadsheet? Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 15% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. 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) a. Would project NPV be higher or lower than that in the Blooper spreadsheet? b. Calculate Blooper's working capital in each year of its project. c. What is the change in project NPV? Complete this question by entering your answers in the tabs below. Would project NPV be higher or lower than that in the Blooper spreadsheetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started