Construction Finance

Using the cash, accrual, percentage of completion, and completed-contract methods of recognizing revenue, calculate the revenues, expenses, Display dollars as whole numbers, and you must use formula or imported numbers in every calculated cell Firm (Unit: $1,000) Total Contract Amount $ Cash Expenditures to 12/31/XX $ Total expenditures to 12/31/XX $ Estimated expenditures to completes Total estimated expenditures S Billings through 12/31/xx $ Cash collectors through 12/31/xx S Cash G & A expense to 12/31/xx Total G & A expenses to 12/31/XX Eagle Construction Company Project A Project B 850 $ 1,100 $ 700$ 700$ 780S 800$ 40 S 280 $ 820$ 1,080$ 800 S 850 $ 740$ 800$ Project C 1,400 $ 940S 1,000S 500 $ 1,500S 1,200 S 900 $ Project D 1,200 550 600 600 1,200 750 750 200 300 Tax rate 23% Revenue Recognitions Cash Accrual % of Completion Completed Contract (Unit: $1,000) (% of Completion) Revenue Project A Expense Profit (% of Completion) Revenue Project B Expense Profit (% of Completion) Revenue Project C Expense 3 Profit 4 (% of Completion) Revenue Project D 6 Expense 7 Profit 8 Profit 9 G&A expenses Total 0 Income before Tax 1 Income after Tax -2