reading and utilizing data
October 4, 2021
answer the question 256
October 4, 2021

mba 620 business finance 3

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. Set up a table for 24 suggested periods, with headings beginning balance, interest earned, payment made, and ending balance.
  2. =PMT(.00375,360,400000)
  3. =PMT(.00333,180,400000)
  4. 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.