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
- 2.38 / (.09 – .02)
- Sell 140 – option 2.40 – exercise 130
Annuities Tab
- —
- Set up a table for 24 suggested periods, with headings beginning balance, interest earned, payment made, and ending balance.
- =PMT(.00375,360,400000)
- =PMT(.00333,180,400000)
- Discuss what should be the decision and factors affecting it
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.