ge Leaming D achtmffdeploymentid=5932632365242709435777379149701337909089538796 srpshotld-20863301 SM Connect login Login to Carvm Scent Dashboard pemail 5 Red Flagt Your F NDTAP Search this cou ty: Replacement Analysis Excel Online Structured Activity: Replacement Analysis The Gilbert Instrument Corporation is considering replacing the wood steamer it currently uses to shape guitar sides. The steamer has 6 years of remaining life. If kept, the steamer will have depreciation expenses of $650 for 5 years and $325 for the sth year. Its current book value is $3,575, and it can be sold on an interne auction site for $4,150 at this time. If the old steamer is not replaced, it can be sold for $800 at the end of its useful life. Gilbert is considering purchasing the Side Steamer 3000, a higher and steamer, which costs $14,000, and has an estimated useful life of 6 years with an estimated salvage value of $1,400. This steamer falls into the MACRS 5 years class, so the applicable depreciation rates are 20.00%, 32,00% 19,20%, 11.529, 11.529, and 5.76%. The new steamer is faster and would allow for an output expansion, so sales would rise by $2,000 per year; even so, the new machine's much greater efficiency would reduce operating expenses by $1.400 per year. To support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would simultaneously increase by $700. Gilbert's marginal federal-plus-state tax rate is 40%, and its WACC is 14% The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below Open spreadsheet Should it replace the old steamer Vind A 11:14 1 O DELL Learning 435777379148eSBN 9781337909686_id=9945387988 snapshotld=208633 html?deploymentid=593263236 M Connect login Log in to Canvas IDTAP Scentsy Dashboard urxnl Ethical Issues For FL. 6 Red Flags Your F... Replacement Analysis 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. The new steamer is faster and would allow for an output expansion, would rise by $2,000 per year; even so, the new machine's much greater efficiency would reduce operating expenses by $1,400 support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would sim increase by $700. Gilbert's marginal federal-plus-state tax rate is 40%, and its WACC is 14%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to questions below. HI X Open spreadsheet Should it replace the old steamer? The old steamer be replaced What is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar. $ Check My Work Reset Problem i DELL Data Insert Formulas Home Review View File Tell me what you Help Arial 10 22 Currency De B 7 U ab Paste 18 $. % 9 688 F A ...AA ndo Font Alignment Number Clipboard 28 fo A B D $650 $325 $3,575 $4.150 $800 3 Old Equipment 4 Depreciation expense, Years 1 to 5 5 Depreciation expense. Year 6 6 Current book value 7 Current market value 8 Market value Year 6 9 10 New Equipment 11 Estimated useful life (in years) 12 Purchase price 13 Salvage value, Year 6 14 Annual sales increase 15 Annual reduction in operating expenses 16 Initial increase in inventories 17 Initial increase in accounts payable 6 $14.000 $1,400 S2000 $1,400 $2.900 $700 Sheet1 + Calculation Mode: Automatic Workbook Statistics Type here to search O 0 6 DC Connect login Log in to Carvas X Excel Scentsy Dashboard sunce File Home template Saved Insert Formulas Data Review View Help Tell me what you want to do 5 Arial 10 23 Paste I B Currency U ab D A IL 191 ilil A- A $. % 48 Conditional Format CA Formatting Table - Styles Insert Delete format Undo Clipboard Font Alignment Number B28 fo Tables B E G Year 2 Year 1 20.00% D Year 3 19 20% 32 00% Year 4 11.52% Year 5 11 52% Year 6 5.76% 40.00% 14.00% Formulas 19 20 MACRS depreciation rates (5-year class) 21 22 Tax rate 23 WACC 24 25 Step 1. Calculation of investment at t= 0 26 Purchase price of new equipment 27 Sale of old equipment 28 Tax on sale of old equipment 29 Change in net operating working capital 30 Total investment outlay 31 32 Step 2. Calculation of annual after-tax cash inflows 33 Annual sales increase $14,000 54150 #N/A #N/A #N/A $2.000 Sheet1 + Calculation de Automat Workbook Statistics Type here to search DELL Review View Help Tell me what you want to do Arial 10 X 09 2 Il bili Currency 1 B U Paste ab D A -A- A $% 88 Conditional Format Cal Formatting as Table Styles Insert Delete da Clipboard Font Alignment Number Tables 3 Cels v fi B D E G STEP 2 COLUIGUI UT ALS WITOWS Annual sales increase Annual reduction in operating expenses Annual increase in pre-tax revenues $2,000 $1,400 5 #N/A 5 After-tax annual revenue increase #NIA 3 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Step 3. Calculation of annual depreciation tax savings 0 1 New equipment 2 Old equipment 3 Change in annual depreciation 4 s Annual dpreciation tax savings 16 57 Formulas $650 -5650 $650 $650 $650 -S650 $650 5650 $650 $650 $325 -$325 Sheet1 + Calculation Mode: Automatic WorkbookStatistics G Type here to seard DELL ge Leaming D achtmffdeploymentid=5932632365242709435777379149701337909089538796 srpshotld-20863301 SM Connect login Login to Carvm Scent Dashboard pemail 5 Red Flagt Your F NDTAP Search this cou ty: Replacement Analysis Excel Online Structured Activity: Replacement Analysis The Gilbert Instrument Corporation is considering replacing the wood steamer it currently uses to shape guitar sides. The steamer has 6 years of remaining life. If kept, the steamer will have depreciation expenses of $650 for 5 years and $325 for the sth year. Its current book value is $3,575, and it can be sold on an interne auction site for $4,150 at this time. If the old steamer is not replaced, it can be sold for $800 at the end of its useful life. Gilbert is considering purchasing the Side Steamer 3000, a higher and steamer, which costs $14,000, and has an estimated useful life of 6 years with an estimated salvage value of $1,400. This steamer falls into the MACRS 5 years class, so the applicable depreciation rates are 20.00%, 32,00% 19,20%, 11.529, 11.529, and 5.76%. The new steamer is faster and would allow for an output expansion, so sales would rise by $2,000 per year; even so, the new machine's much greater efficiency would reduce operating expenses by $1.400 per year. To support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would simultaneously increase by $700. Gilbert's marginal federal-plus-state tax rate is 40%, and its WACC is 14% The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below Open spreadsheet Should it replace the old steamer Vind A 11:14 1 O DELL Learning 435777379148eSBN 9781337909686_id=9945387988 snapshotld=208633 html?deploymentid=593263236 M Connect login Log in to Canvas IDTAP Scentsy Dashboard urxnl Ethical Issues For FL. 6 Red Flags Your F... Replacement Analysis 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. The new steamer is faster and would allow for an output expansion, would rise by $2,000 per year; even so, the new machine's much greater efficiency would reduce operating expenses by $1,400 support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would sim increase by $700. Gilbert's marginal federal-plus-state tax rate is 40%, and its WACC is 14%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to questions below. HI X Open spreadsheet Should it replace the old steamer? The old steamer be replaced What is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar. $ Check My Work Reset Problem i DELL Data Insert Formulas Home Review View File Tell me what you Help Arial 10 22 Currency De B 7 U ab Paste 18 $. % 9 688 F A ...AA ndo Font Alignment Number Clipboard 28 fo A B D $650 $325 $3,575 $4.150 $800 3 Old Equipment 4 Depreciation expense, Years 1 to 5 5 Depreciation expense. Year 6 6 Current book value 7 Current market value 8 Market value Year 6 9 10 New Equipment 11 Estimated useful life (in years) 12 Purchase price 13 Salvage value, Year 6 14 Annual sales increase 15 Annual reduction in operating expenses 16 Initial increase in inventories 17 Initial increase in accounts payable 6 $14.000 $1,400 S2000 $1,400 $2.900 $700 Sheet1 + Calculation Mode: Automatic Workbook Statistics Type here to search O 0 6 DC Connect login Log in to Carvas X Excel Scentsy Dashboard sunce File Home template Saved Insert Formulas Data Review View Help Tell me what you want to do 5 Arial 10 23 Paste I B Currency U ab D A IL 191 ilil A- A $. % 48 Conditional Format CA Formatting Table - Styles Insert Delete format Undo Clipboard Font Alignment Number B28 fo Tables B E G Year 2 Year 1 20.00% D Year 3 19 20% 32 00% Year 4 11.52% Year 5 11 52% Year 6 5.76% 40.00% 14.00% Formulas 19 20 MACRS depreciation rates (5-year class) 21 22 Tax rate 23 WACC 24 25 Step 1. Calculation of investment at t= 0 26 Purchase price of new equipment 27 Sale of old equipment 28 Tax on sale of old equipment 29 Change in net operating working capital 30 Total investment outlay 31 32 Step 2. Calculation of annual after-tax cash inflows 33 Annual sales increase $14,000 54150 #N/A #N/A #N/A $2.000 Sheet1 + Calculation de Automat Workbook Statistics Type here to search DELL Review View Help Tell me what you want to do Arial 10 X 09 2 Il bili Currency 1 B U Paste ab D A -A- A $% 88 Conditional Format Cal Formatting as Table Styles Insert Delete da Clipboard Font Alignment Number Tables 3 Cels v fi B D E G STEP 2 COLUIGUI UT ALS WITOWS Annual sales increase Annual reduction in operating expenses Annual increase in pre-tax revenues $2,000 $1,400 5 #N/A 5 After-tax annual revenue increase #NIA 3 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Step 3. Calculation of annual depreciation tax savings 0 1 New equipment 2 Old equipment 3 Change in annual depreciation 4 s Annual dpreciation tax savings 16 57 Formulas $650 -5650 $650 $650 $650 -S650 $650 5650 $650 $650 $325 -$325 Sheet1 + Calculation Mode: Automatic WorkbookStatistics G Type here to seard DELL