1 / 23

Financial Calculations Made Easy

Perform various financial calculations easily and accurately with these formulas. Includes addition, subtraction, multiplication, division, square roots, future and present value, loan payments, averages, and more.

erasmus-karsten
Télécharger la présentation

Financial Calculations Made Easy

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Add the Values in C10 and M12 =C10+M12

  2. Subtract the value in A11 from the value in B16 =B16-A11

  3. Multiply the value in A7 by the value in D10 =A7*D10

  4. Raise the Value in B10 to the 5th power =B10^5

  5. Divide the Value in A14 by 3 =A14/3

  6. Subtract the Value in B5 from the Value in C7 and then Divide by 3 =(C7-B5)/3

  7. Add the values in E17 and A14 and then multiply by 10 =(E17+A14)*10

  8. Round B5 to the nearest thousanth =ROUND(B5,3)

  9. Determine the Square Root of 466 =SQRT(466)

  10. Determine the Largest value in cell range B3 to B20 =MAX(B3:B20)

  11. Determine the Future Value of an account at the end of 5 years after making $400 monthly payments at a return of 8% =FV(.08/12,5*12,400) (rate,# of payments,amount)

  12. Determine the Present Value of a college fund where you make 25 yearly payments of $4,000 at 13%. =PV(.13,25,4000)

  13. Calculate the monthly paymenton a 30 year loan of $75,000 at6% interest. =PMT(.06/12,30*12,75000)

  14. Determine the Smallest Cell Value in B3:B20 =MIN(B3:B20)

  15. Determine the Average of cell range E7:E19 =AVERAGE(E7:E19)

  16. Determine the number of cells in the range C5:C154 =COUNT(C5:C154)

  17. Determine the monthly car payment for a $8000 loan for 3 ½ year at 8% APR. =PMT(.08/12,3.5*12,8000)

  18. Divide the value in A6 by 2, then subtract the value in B6 =A6/2-B6

  19. Subtract the value in B6 from the value in A6, then divide by 2 =(A6-B6)/2

  20. Add the values in A3 and A4, then multiply the sum by 3 =(A3+A4)*3

  21. Determine the product of C5 and C6 and then add 50 =C5*C6+50

  22. Rasies the value in A3 to the 3rd power, then divides the result by the value in A4 =A3^3/A4

  23. Divides 100 by the value in C4, then multiplies the result by the value in C3 =100/C4*C3

More Related