Перейти к содержимому

ACCA FM Duo Co | Investment Appraisal NPV in Excel | Full 20 Marks + Theory

Robin Academy

0:00 / 0:00

ACCA FM Duo Co | Investment Appraisal NPV in Excel | Full 20 Marks + Theory

199 просмотров · 2 недели назад
Robin Academy
12 подписчиков
199 просмотров · 2 недели назад
ACCA FM DUO CO: Investment Appraisal NPV in Excel | Full 20-Mark Solution In this ACCA Financial Management (FM) Section C walkthrough, we solve the complete DUO CO Investment Appraisal question worth 20 marks. This video covers the entire question - Part A and Part B, including the 7 mark theory section that is often skipped in other walkthroughs. 💻 Part A is solved ENTIRELY IN EXCEL, step-by-step, mirroring the real ACCA CBE spreadsheet environment so you can follow along and build the exact calculation models needed on exam day. 📚 Part B : 7 mark Theory is also fully structured and explained with proper exam technique. --- 📥 DOWNLOAD THE EXCEL FILE: Want to practice with the exact spreadsheet used in this video? Download the solved Excel templates inside our Telegram group: 🔗 Telegram: https://t.me/RobinAcademyOfficial --- ⏱️ TIMESTAMPS 00:00 - Question Overview and Exam Strategy to Solve NPV(a) 13:15 - Setting up NPV Solution Format/Proforma in Excel 24:25 - Working 1: Contribution Computation 33:35 - Taxable Cash Flow 34:35 - Tax Computation (1 Year in Arrears) 37:55 - Working 2: After-Tax WACC Discounting Rate 42:15 - Working 3: Tax Allowable Depreciation (TAD) and Tax Benefit 53:00 - After Tax Cash Flows 57:15 - Present Value of Cash Flow 01:04:15 - Final Net Present Value (NPV) Calculation & Investment Decision 01:08:50 - Part (b) Theory: Risk vs Uncertainty, Sensitivity & Probability Analysis --- 📌 WHAT THIS VIDEO COVERS: ✅ ACCA Financial Management (FM) Section C ✅ Investment Appraisal & Discounted Cash Flows (DCF) ✅ NPV calculation & formula application in Excel ✅ DUO CO – Full 20-mark past question walkthrough ✅ Part A: Complete numerical model in Excel ✅ Part B: 7-mark written theory & strategic analysis ✅ Real CBE spreadsheet exam technique & best practices If you're preparing for ACCA FM and want to improve your confidence with Section C Investment Appraisal questions, this walkthrough will help you practice the complete question from start to finish. --- 📚 ACCA FM SECTION C PLAYLIST Watch the complete ACCA FM Section C series here: 🔗 Playlist:    • ACCA FM Investment Appraisal Section C Que...   (More Section C questions will be added to this playlist as the series continues.) --- 📲 JOIN OUR TELEGRAM COMMUNITY Join Robin Academy on Telegram for free Excel practice templates, exam updates and student discussions: 🔗 Telegram: https://t.me/RobinAcademyOfficial 📸 FOLLOW ROBIN ACADEMY ON INSTAGRAM For ACCA updates, study content, exam tips, and more: 🔗 Instagram: https://www.instagram.com/robinacadem... --- 🎓 ABOUT ROBIN ACADEMY Robin Academy is focused on helping ACCA students understand core concepts clearly and approach CBE exam questions with total confidence. If this video helps you, please LIKE 👍, COMMENT 💬and SUBSCRIBE 🔔 to support the channel and stay updated when the next ACCA FM walkthrough is uploaded. Know another student preparing for FM? Share this video with them! ❤️ #ACCAFM #InvestmentAppraisal #ACCA