how did he get this answers?
13. You are planning a project. Your estimated cost and bid price are shown; the owner will retain 10% each payment throughout the project, and the cash flow is in the table. Note that in the cash required column negative numbers indicate that you have money in the bank. Show your work for b, c, and d. Estimated Cost5 1.285,000 Sid Price 51413.500 Monthly Interest 1 0 55 every Retainage 10% payment payment received 30 days later 5 X Month Cost Invoice Amount Rec'd Cash Required Interest 121 56 40,000 110,000 $185,000 $225,000 $255.000 $265.000 5155,000 S 50,000 S 39,600 $ 108,900 $ 183,150 $222,750 5252,450 $ 262,350 $ 153,450 $ 190,850 x X $ 39,600 (B) $183,150 $ 222,750 $252,450 $262,350 $ 153,450 $ 190,850 40.000 150.2005296,351 5413,933 (0) 5532 542 5437,754 5227,593 75.281 51115192) 200 $ 751S 1.482S 2,070 S 2,439 (D) S 2,189 S 1,138 S 376 40,200 $ 150,9515297,8335416,002 $490.292 $535,204 $439,943 5228,731 $ 75,658 $(115,192) 5 $ $ Total a. (3) What is the maximum amount you will need to borrow from the bank or other sources to finance the construction of this project? $ $ 535,204 b. (2) Calculate the amount for cell B $ 108,900 c. (2) Calculate the amount for cell C 413933 + 2070 + 255.000 - 103,150 =16437,853 d. (2) Calculate the amount for cell D 532 542(0.005)=\$ 2662 535204 - 532 542 = 240 V e. (3) What was the original expected profit (as a percent)?! 1413 500 no east i 1gpOHylb7Sihtatp 413.933 4 2070 + 255,000 - 103,150 = $ 487,853 d. (2) Calculate the amount for cell D 532,542(0.005) =\$ 2662 535204 - 532542 = 2662 v e. (3) What was the original expected profit (as a percent)? 1413500 1235000:11 10% profit u f. (3) After paying the interest, how much profit is there at the end of the job (again as a percent)? 115192 115192 - (40,wo + 110,+ 189,00*225000+ 255000+21501 1285000 1550044 10000) O 8.96% 13.96%)/ 13. You are planning a project. Your estimated cost and bid price are shown; the owner will retain 10% each payment throughout the project, and the cash flow is in the table. Note that in the cash required column negative numbers indicate that you have money in the bank. Show your work for b, c, and d. Estimated Cost5 1.285,000 Sid Price 51413.500 Monthly Interest 1 0 55 every Retainage 10% payment payment received 30 days later 5 X Month Cost Invoice Amount Rec'd Cash Required Interest 121 56 40,000 110,000 $185,000 $225,000 $255.000 $265.000 5155,000 S 50,000 S 39,600 $ 108,900 $ 183,150 $222,750 5252,450 $ 262,350 $ 153,450 $ 190,850 x X $ 39,600 (B) $183,150 $ 222,750 $252,450 $262,350 $ 153,450 $ 190,850 40.000 150.2005296,351 5413,933 (0) 5532 542 5437,754 5227,593 75.281 51115192) 200 $ 751S 1.482S 2,070 S 2,439 (D) S 2,189 S 1,138 S 376 40,200 $ 150,9515297,8335416,002 $490.292 $535,204 $439,943 5228,731 $ 75,658 $(115,192) 5 $ $ Total a. (3) What is the maximum amount you will need to borrow from the bank or other sources to finance the construction of this project? $ $ 535,204 b. (2) Calculate the amount for cell B $ 108,900 c. (2) Calculate the amount for cell C 413933 + 2070 + 255.000 - 103,150 =16437,853 d. (2) Calculate the amount for cell D 532 542(0.005)=\$ 2662 535204 - 532 542 = 240 V e. (3) What was the original expected profit (as a percent)?! 1413 500 no east i 1gpOHylb7Sihtatp 413.933 4 2070 + 255,000 - 103,150 = $ 487,853 d. (2) Calculate the amount for cell D 532,542(0.005) =\$ 2662 535204 - 532542 = 2662 v e. (3) What was the original expected profit (as a percent)? 1413500 1235000:11 10% profit u f. (3) After paying the interest, how much profit is there at the end of the job (again as a percent)? 115192 115192 - (40,wo + 110,+ 189,00*225000+ 255000+21501 1285000 1550044 10000) O 8.96% 13.96%)/