- This topic has 3 replies, 2 voices, and was last updated 4 years ago by
.
- Posts
Hello
How do I solve MM2 on speadsheet?
I will be attempting CBE exam we’ve no access to a working paper
How to solve for Ungeared KeI assume that you are in a country where the AFM exam is CBE and not paper based.
You will not be able to use working paper, but there is a scratchpad available on the computer exam where you can do workings.
With regard to solving MM2 and unguarded Ke, I assume that you are familiar with spreadsheets. However for complicated workings you can do the workings for each part separately just as you would be likely to do if you were taking a paper based exam.
Best is to look at the specimen computer based exam on the ACCA website to see what it is like.
Yes I am in a country where AFM will be remote CBE for this september.
I was having a go at the CBE practice platform on the ACCA wesbite but came unstuck at the MM2 equation
I was just wondering if there was a way to solve for unknown variable x in the spreadsheet itself?, because I tried doing on the scratch pad and it proved difficult trying to re-arrange the equation to solve for x (Kei).
For eg I’ve learned that there is a built in function/formula for
1) NPV discouting at any df
2) MIRR
3) IRR
4) BSOP model normal distribution (no need to refer to sheet)There might be more
- You must be logged in to reply to this topic.