Back

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • April 12, 2021 at 4:43 pm in reply to: Welcome to the Forum + Forum Guidelines #17897
    Sherry JohnsonSherry Johnson
    Participant

    In building the Amortization Schedule I noticed in the video you used Column C (The months) to start each formula such as =IF(C16-“”,””,I15) but when I got behind understanding the formulas I looked at your completed template and you used Column B (Year) to start all the formulas such as =IF(B16=””,””,I15)

     

    Does it matter if year or month is used in the formula as long as none of them = 0?

    March 19, 2021 at 2:40 pm in reply to: Acquisition Cost #17731
    Sherry JohnsonSherry Johnson
    Participant

    In the same course, my spreadsheet numbers match yours but I think the Quiz wanted a different Net Reversion Value for the correct answer. Can you please check?  We both had $33,899,784 but I believe the Quiz wanted 29MM for the answer.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)