Can you correct my formulas on the excel sheet?

For the financing tab, question 1, add 350 year 0 which brings the final answer to -20.13. For question 2, similarly, the final answer is -3.15. In the valuation tab, find sell, option and exercise numerics and sum. Question 4 needs revised. On the annuities tab, review and revise questions 4 and 5.

Additionally, more helpful information.

Valuation Tab

1. 2.38 / (.09 - .02)
2. Sell 140 – option 2.40 – exercise 130

Annuities Tab

1. --
2. Set up a table for 24 suggested periods, with headings beginning balance, interest earned, payment made, and ending balance.
3. =PMT(.00375,360,400000)
4. =PMT(.00333,180,400000)
5. Discuss what should be the decision and factors affecting it