Recent content by LittleJonJon

  1. LittleJonJon

    Projected Cash Flows: Present and Future Worth Calculations

    Okay I took your advice and 2010-2023 years in the past (their worth should be higher considering the interests rate) and values in 2025-2033 that their worth should be lower in 2024.) This is because we are discounting the future amount back to the present year (2024). The formula correctly...
  2. LittleJonJon

    Projected Cash Flows: Present and Future Worth Calculations

    updated information Consider the following income and expenditure of a project over past years and expected in future years. The income and expenditures happen on the last day of each year. The present time is at the end of 2024. The interest rate of 12% compounded annually...
  3. LittleJonJon

    Projected Cash Flows: Present and Future Worth Calculations

    I did =NPV(12%,B3:B25)+B2 = 110.11 =FV(i%,n,A,P) = SUM(E2,E,25)=-1492
  4. LittleJonJon

    Projected Cash Flows: Present and Future Worth Calculations

    That is the formula from the textbook.
  5. LittleJonJon

    Projected Cash Flows: Present and Future Worth Calculations

    Consider the following income and expenditure of a project over past 23 years and the interest rate of 12% compounded annually. $$ \begin{array}{|c|c|} \hline \text{Year} & \text{Cash Flow (CF)} \\ \hline 2000 & -6543 \\ 2001 & 2300 \\ 2002 & \\ 2003 & 8200 \\ 2004 & \\ 2005 & 810...