BUS321 - Capital Budget Practice Problem Nov 2-6 2020 Table 1 is an example of a Capital Budget Analysis for a 5 year project with the characteristics given in the Table 2. In Table 1 the yellow highlight color cells contain numbers you enter from Table 2. Note the format of the numbers. The cross hashed cells have no content. The other cells have formuli to perform the andropriate calculations. Table 1. Cap Bud Spreadsheet Exer Number 1 Mar 11 2020 appropriate calculations. Table 1. Cap Bud Spreadsheet Exercise Number 1 March 11 2020 Discount Rate 5.000 Tax Rate 30.0% YEAR Bezinningsinya mente Building 5525UUUN Equipment $100,000 Working Capital SS000 oral $400,000 Queri Cash Flows Cash Reven 2000 2001 200.COLE KOOKOU 200,00 Variable Cash Costs 53000 535000 35000 35000 35.000 Fixed Cash Cash $225,00 52550 250 525,000 $20,000 Operating Cash Flow 140 140.000 14000 14000 140,000 Buildin SL Dupre (20 YTL SS1200 $12500 512 50E 512 5.00 12.500 Loup SL Dunya) ISTERSE 1422 SEP 230 514,286 51428 Ta 5330 583.900 396 8831964 533,96 Cash Flow after tax LUB,036 06.038 LOGO30 100.000 1000SC Edinach Flow Salvare Value of Buildin SOLO Salvare Vol Liquipment 51000 urn of Workinca 50.000 Total SOUCO Nesh Flow NCF) ES100.00L 1106,036 106,036 06 ORE 106,0 26,038 Port Value of NCE SULLE LIUOSE 196,178 STRESSERE Total Net Present Value $176,60 Table 2. Cap Bud Spreadsheet Exercise Number 1 Berinin Assumptions Discount Rate 5000 Tax Rates 30.00 Project Lil Year Bezinning Cash Investment Flos Buildina 250.000 Equipment 3100,000 Workimai Operation Aumptions Annual Cash Revenu $200,000 Annual Variable Cash Costs $35.000 Annual Fixed Cash Coste $25,000 Ending Value Assumptions Salvage Value of Buildings 590,000 Salvare Value of Equipment S10,000 Return of Working COP $50,000 oblem 1 w Data