Hello, I just need help understanding how these solutions in the chart were done through excel for clarification. Below I posted the question along with the excel chart answers for guidance. Would someone be able to replicate the exact same chart but demonstrate the excel formulas for each cell to show how each cell came to an answer? I will leave a thumbs up!

ANSWERS IN EXCEL CHART:

Just need a replica image of this but with the formulas for each cell, please and thank you!

Questions 20 to 29 Deliverable CPI SPI ETC EAC 0.90 Design Complete Code Complete Test Complete Total 0.90 $ 1,111 $ 11,111 $ 20,000 $ 21,000 $ 10,000 $ 11,000 0.90 41,333 $ 53,333 0.75 PV EV AC SV After 10 days $ 10,000 $ 9,000 $ 10,000-$ 1,000-$ 1,000 $ $ $ 1,000-$ 1,000 $ $ $ $ 1,000-$ 1,000 $ $ 10,000 $ 9,000 $ 12,000 - $ 3,000 $ 1,000 After 20 days $ 10,000 $10,000 $ 12,000-$ 2,000 $ $ 20,000 $ 16,000 $ 18,000-$ 2,000-$ 4,000 $ $ $ 1,000 - $ 1,000 $ $ 30,000 $ 26,000 $ 31,000-$ 5,000-$ 4,000 After 30 days $ 10,000 $10,000 $ 13,000-$ 3,000 $ $ 20,000 $ 20,000 $ 19,000 $1,000 $ $ 10,000 $10,000 $ 13,000 - $ 3,000 $ $ 40,000 $ 40,000 $ 45,000-$ 5,000 $ Design Complete Code Complete Test Complete Total 0.83 0.89 1.00 $ $ 12,000 0.80 $ 4,500 $ 22,500 $ 10,000 $ 11,000 0.87 16,692 $ 47,692 0.84 Design Complete Code Complete Test Complete Total 0.77 1.05 0.77 0.89 1.00 1.00 1.00 1.00 $ 45,000