Access over 20 million homework & study documents

Calc

Content type
User Generated
Subject
Business
Type
Homework
Rating
Showing Page:
1/4

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/4

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/4

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 4 pages?
Access Now
Unformatted Attachment Preview
Use your PV function in Excel. Click formulas, insert function, financial, PV. Future value (FV) Interest rate (Rate) Number of years (NPER) Present value $ 500.000,00 15% 20 ($30.550,14) You will need to depost $30,550.14 today Use your FV function in Excel. Click formulas, insert function, financial, FV. Present value (PV) Number of years (NPER) Interest rate (Rate) Future value $ 200.000,00 5 5% $255.256,31 Use your RATE function in Excel. Click formulas, insert function, financial, RATE. Initial investment (PV) Future value (FV) Number of years (NPER) 100000 300000 10 Interest rate (Rate) 11,61% Use your PV function in Excel. Click formulas, insert function, financial, PV. Period payment (PMT) Interest rate (Rate) Number of periods (NPER) $ 50.000,00 11% 10 Value of annuity $ (294.461,60) Use your RATE function in Excel. Click formulas, insert function, financial, RATE. Future value (FV) yearly investment (PMT) Number of periods (NPER) Interest rate (Rate) $ 400.000,00 $ 10.000,00 20 6,77% Year 0 1 2 3 NPV Project A -CF $ (10.000,00) $ 5.000,00 $ 5.000,00 $ 5.000,00 $ 2.434,26 Project B- CF $ (55.000,00) $ 20.000,00 $ 20.000,00 $ 20.000,00 $ (5.262,96) ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4