please just fill one column ( month 5)

also show how you got your calculations for Amount required, invoice, cash required and interest.

thank you....

Cash flow, chapter 3. This question is very similar to Example 3.2 and Figure 3.8 in our text. One difference is that the example retains 10% for half the project and here we are retaining 5% from every payment. After the 8th period you will invoice for the cost that month plus all the money retained previously (the same as in the text) for profit Estimated cost $5,550,000 Bid Price $6,105.000 estimated cost marked up Monthly interest 0.50% Retainage every payment payment received 10 days later Month $ 500,000 $ 650,000 $ 900,000 $ 1,100,000 $ 1,000,000 $ 800,000 $ 400,000 $ 200,000 $ Invoice Amount Rec'd Cash Required Interest $ 522,500 $ 679,250 $ $ 522,500 $ $ 500,000 $ 1,152,500 $ 1,505,70 940.500 679.250 1,964,191 Total S502.500 $ 1,158.263 $ 1.543,441 $ 1,994.012 Fill in all the empty boxes. Determine the actual profit after interest is paid ($42,483 in the text) Determine the maximum amount of money required it will be the largest number in the "Total" line). Determine the total interest paid. Cash flow, chapter 3. This question is very similar to Example 3.2 and Figure 3.8 in our text. One differe pe s.2 and Figure 3.8 in our text. One difference is that the example retains 10% for half the project and here we are retaining 10% from everament the period you will invoice for the cost that month plus all the money retained period you will invoice for the con previously the same as in the text). payment. After the Estimated cost $5.550.000 Bid Price $6.105.000 estimated cost marked up som for profit Monthly interest Retinage Nevery payment payment received 10 days later Month 300,000 $ $ 500,000 $ $ Amount Rec'd 650,000 $ 900,000 $ 522,500 $ 679,250 $ $ 522,500 $ 1,152,500 $ 1,535,783 $ 5.763 $ 7,679 $ 1.26 $ 1,541.441 $ 1,100,000 $ 1,000,000 $ 40,500 679.250 940530 1,964,191 9,621 1,974,012 Cash Required $500,000 $ $ 2,500 $ $502, 500 Total Fill in all the empty boxes. Determine the actual profit after interest is paid (542,483 in the text). Determine the maximum amount of money required (it will be the largest number in the "Total" line). Determine the total interest paid. it. One difference is that the example retains 10% for half the project and you will invoice for the cost that month plus all the money retained 800,000 $ 400,000 $ 200,000 Sum across Double check $ 5,550,000 $ 6,105,000 $ 6,105,000 Profit: st number in the "Total" line)