Thanks for sharing this with us. You are amazing.
Hi Jae! Thank you for creating this concise and essential Excel Test prep video! I have a question regarding assumption e). The expected cost is given as $20,000 per month starting Q2 2024. Wouldn't it be $60,000 when we incorporate this assumption in our quarterly model?
Hello Sunny! You are absolutely right. I designed this and it seems I misinterpreted this assumption. Great attention to detail!
It does not stop your sharing from being one of the best. Thank you again for making such invaluable content! I look forward to your next upload. @@ShinFinancials
Great work 👍 question: the net income growth comes mainly from service revenue growth, but I don’t think thats realistic without any CoGS(service headcount) increase. Should I point that out during the test?
Yes! These tests will usually have a clause that states "Note any other assumptions you've made". Catching the CoGS increase shows your insight to business operations and is definitely a good call out!
link Is broken, can you fix it please?
It looks like the file got taken down. Are you able to send it to me?
Why revenue is recorded as Debit? and the according P&L impact is neg?
Hi! You'll see some Debit entries for revenue when there are reversals, and same for the Expense side!
thanks for sharing! noted that on the Index tab, line 33 and 41 have the same GL account number