Question: Please solve in excel with formulas PLEASE ANSWER FAST WITH THE FORMULAS FOR INSTANT UPVOTE Firm (Unit: $1,000) Total Contract Amount Cash Expenditures to 12/31/xx
Please solve in excel with formulas
PLEASE ANSWER FAST WITH THE FORMULAS FOR INSTANT UPVOTE

Firm (Unit: $1,000) Total Contract Amount Cash Expenditures to 12/31/xx Total expenditures to 12/31/xx Estimated expenditures to complete Total estimated expenditures Billings through 12/31/XX Cash collectors through 12/31/xx Cash G & A expense to 12/31/xx Total G & A expenses to 12/31/xx $ $ $ $ $ $ $ Project A 850 $ 700$ 780 $ 40 $ 820 $ 800$ 740$ Project B 1,100 $ 700 $ 800 $ 280 $ 1,080$ 850 $ 800 $ Project C 1,400 $ 940 $ 1,000 $ 500$ 1,500 $ 1,200 $ 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 Profit % of Completion) Revenue Project D Expense Profit Profit G & A expenses Total Income before Tax Income after Tax Firm (Unit: $1,000) Total Contract Amount Cash Expenditures to 12/31/xx Total expenditures to 12/31/xx Estimated expenditures to complete Total estimated expenditures Billings through 12/31/XX Cash collectors through 12/31/xx Cash G & A expense to 12/31/xx Total G & A expenses to 12/31/xx $ $ $ $ $ $ $ Project A 850 $ 700$ 780 $ 40 $ 820 $ 800$ 740$ Project B 1,100 $ 700 $ 800 $ 280 $ 1,080$ 850 $ 800 $ Project C 1,400 $ 940 $ 1,000 $ 500$ 1,500 $ 1,200 $ 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 Profit % of Completion) Revenue Project D Expense Profit Profit G & A expenses Total Income before Tax Income after Tax
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
