Ray, thank you very much for your help. The only thing: I do understand the process very very well (and have tons of experience, and I good at constructing excel annuity tables), the only issue I am struggling with sometimes is math. So, I am doing my best to revive my basic math as well as math...
you see, this video shows truly basic macro, and these steps work in any Excel except for my one on Mac. Shall I do something differently to make sure it works on my one too? I am not talking about profound issues; I just need to record the same thing shown in the video.
Homework Statement
Hello!
There is a function in Excel NPER which gives the number of periods/years.
Here is the data:
Present Value = 7 500
Annual rate 18%
Number of periods per year 12
Period rate 0.18/12=0.015
Monthly payment -125
Task to find number of years to pay-off loan with minimum...
I am not sure I am that technically informed. I presume I did write the macro from scratch, just as it is shown in the video attached. The result, well no result actually. I've tried it many many times by creating different tables.
Homework Statement
Hello!
I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing.
No problems with recording separate macros with relative or absolute reference.
Problems description:
I have few sheets with...
Siron,
I assume that v1, v2, v3 are for vector V (first one in my example) and vector W is the second one. I didn't think that it is important to state that :)
Hello!
Christina, thank you for this thread. I also have the same issue.
I like Serena, I would be grateful for your further help.
If given vectors are (1,2,3) and (3,6,9) that have v3 = v1+v2, does it mean that the whole V vector or W vector lies only on XOY plane (two dimensional) and OZ is...
Homework Statement
Hello!
Revising geometric series, I have understood that I have the following issue - I have read again about these series and, please, take a look at what I have gotten as a result (picture attached).
If I calculate a future cash flow, that is I take, for example, a = 0,5...
simple as it is! :) Thank you so much! Right! kindergarten issue - sometimes it happens :) Please, take a look at the following:
1) in case 80 000 is 100%, then 80 000 less 13% is 0.87 of 80 000 and equals 69 600
to "restore" back to 80 000 we have to multiply 69 600 by 1.1494 which is...
I've tried to delete this particular massage to repost it as a new thread because it refers to a bit different topic, but couldn't, so I have deleted the text