Question: When using the excel FV, what would be FV's value at 12% over 15 years at $169,000,000 and $155,000,000? Does type need to be considered

 When using the excel FV, what would be FV's value at

When using the excel FV, what would be FV's value at 12% over 15 years at $169,000,000 and $155,000,000? Does type need to be considered in the answer? Are the inputs the rate (.12)/ number of installments(15) and the dollars($169,000,000 as an example). Am I assuming that these FV with compound over time?

Estimated cost of new ship Estimated period of cash flows in years $ 200,000,000 15 equired For each of the itineraries, calculate the present values of the cash flows using required rates of turn of both 12 and 16% using both present value factors and separately using Excel PV function. ssume a 15-year time horizon. Should the company purchase the ship with either or both required Ise Appendix Table B9.2 to arrive at the factor) s-chegg question.JPG ee all photos + Add to Rate Number of periods Cash Flow Future value Type Caribbean/Alaska Caribbean/ Eastern Canada 12% 16% 12% 16% 15 15 15 15 $ 169,000,000 $ 169,000,000 $ 155,000,000 $ 155,000,000 0 0 0 0 PV the PV values in cells D49, E49, F49, G49, use the Microsoft excel functions. If you need help with the ex

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!