Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based off information provided what would the capital budgeting criteria be? Thank you in advamce! 65 Discount rate 5.00% % years 66 Pay_Back (years) 67
Based off information provided what would the capital budgeting criteria be?
65 Discount rate 5.00% % years 66 Pay_Back (years) 67 Discounted Pay_Back (years) 68 Profitability Index years 69 Net Present Value NPV dollars 70 Internal Rate of Return IRR 71 % 2022 2021 2024 44 Free Cash Flow 45 46 Sales -Costs 48 Depreciation 49 EBIT 50 Taxes 51 Net Income 52 Depreciation 53 Operational Cash Flow 54 Change Net Working Capital Change Fixed Assets 56 FREE CASH FLOW 10 $ 5 5 $ 5 5 $ s 40,000 $ 172.00 212.80015 400,000 $ 340,000 5 31,104 $ 28.8965 7.224 5 21,672 31.104 $ 52,775 S 9.920 $ 2 416,000 $ 353,600 $ 31.1045 31,2965 7,8245 23,472 $ 31,1045 54,576 5 1.997 S 432,640 S 367,744 5 31,1045 33,7925 8.4485 25,3445 31.1045 56,4485 2.0775 2025 ta 449,46 $ 382,454 S 31.1045 36,3885 9.0975 27,2915 31.104 S 58,3955 2.700 5 5 55.6955 2026 5 472.443 From How 30 401,577 Sales 31.104 From How 31 39,762 9,941 Taxes bitxell GIO 29,822 31,104 From How 31 60,926 156.693). From How 26 28,762 From Now 41 88857 $ 5 $ 5 5435 52.579 $ 42.8565 58 Cumulative Free Cash Flow $ (212,800) 5 (169,944) $ (117,365) S (62.994) S (7.298) 5 81,559 This is based on Rov S 47,689S Present Value FCF Cumulative Present Value FCF (212,800) S (212,800) S 40,8165 40,816 S 46,966 S 148,063 S 45,820 $ 197,494 S 69,619 Select first the disc 384,706 Based on Row 60, $ 97,765 $ 2024 2026 3 Net Working Capital Cash Flows 2022 ta 2023 to2 2025 ta4 two ta5 3 S 40,000 $ 51,917 S 49,920 $ 9,920 S Required NWC Change in NWC 53,994 S 2.077 S 56,693 2,700 $ Required (56,693) This row 1,997 S Depreciation Table 2022 ta1 2023 t=2 2024 t=3 2025 t4 2026 t=5 to $ 31,104.00 $ 31,104.00 $ Annual Depreciation Book Value 31,104.00 5 141,695.00 5 31,104.00 $ 48,384.00 $ 31,104.00 Equipme 17,280.00 Book val 79,488.00 $ s 110,592.00 $ 172,800.00 2022 t=1 Fixed Assets Cash Flows 2023 t-2 2024 t=3 2025 t=4 2026 tas t=0 from C s 160,000 12,800 from C s S Equipment Installation Costs Resale Value Tax Effect Change in Fixed Assets S 32,000.0 from 3,283.4 Tax R 28,761.6 This ro s $ 172,800 sis and Decision Example FCF. Criteria $400.000 and 200.000 S100 000 RC Select a yearly amount Select a growth rate between Select a rate between Select a tax rate between Select a cate between 90% 30% > and 22 28% 15 Data 7. Sales year 2072 Sales Growth Rate Costs of sales 10 Tax Rate 11 NWC as percentage of Sales 12 11 Equipment Contatto Installation Costs atteo 15 Resale Value ott 5 16 Ending Hook Value 30 and 10 5 5 5 5 160,000 17.00 12.000 17,280 to indicates the beginning of 2022 11 indicates the ending 2012 and the beginning of year 2021, on and so forth Thank you in advamce!
Step 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