Academic financial analysis requires a synthesis of theoretical frameworks and precise mathematical execution. For EFN406 Managerial Finance, students must demonstrate mastery over time value of money (TVM) applications, security valuation, and capital raising mechanisms within the Australian regulatory landscape. This assignment demands a dual-submission approach—combining manual algorithmic solutions with functional Excel modeling—to ensure both conceptual understanding and professional technical competency.
EFN406: Managerial Finance
Assignment Part A: Financial Mathematics and Security Valuation
Semester 1, 2026
Weight: 10% | Total Marks: 10 (1 mark per question)
Format: Combined Word/Excel submission. Manual formulas and Excel functions are both mandatory.
Assessment Overview and Submission Requirements
This assessment evaluates your ability to apply financial mathematics to real-world scenarios, including mortgage structures, annuity funding, and security pricing. Every question requires a correct numerical answer, a step-by-step manual calculation using standard financial formulas, and a functional Excel verification. Partial marks are not awarded; accuracy to the specified decimal places is critical to passing the quality assurance audit for this unit.
- Precision: PV/FV to the nearest dollar; Prices to two decimal places; Rates to one basis point (0.01%).
- Integrity: All work must be individual. Automated scanning software will be utilized to detect collusion or AI-generated formatting inconsistencies.
- Tools: Cash flow maps (timelines) and amortization tables are highly encouraged for complex multi-period problems.
Problem Set (Selected Core Challenges)
Question 1: Mortgage Amortization and Interest Analysis
Ed and Susie are purchasing a $625,000 property with a $40,000 deposit. The remaining $585,000 is financed over 25 years at a monthly interest rate of 0.4075%.
- Calculate the fixed monthly repayment (PMT).
- Determine the total interest expense incurred specifically during the third year (months 25–36).
- Calculate the outstanding loan balance (PV) immediately prior to the 140th payment.
Question 7: Multi-Stage Dividend Growth Valuation
Polycorp’s valuation requires a non-constant growth model. $D_0$ is $5.55. Calculate the current ex-dividend share price ($P_0$) given the following projections:
- Year 1: $6.00; Year 2: $6.60.
- Years 3–4: 6.5% annual growth.
- Years 5–6: 3% annual growth.
- Year 7 onwards: 2% perpetual growth.
- Required Return ($k_e$): 10.35% pa.
Question 10: Corporate Finance – Rights Issues
Jasper Holdings Ltd seeks to raise $120 million. Current Price: $10.00. Shares Outstanding: 240 million. Subscription Price: $8.00.
- Determine the number of new shares to be issued.
- Calculate the ‘N’ (number of rights required for one new share).
- Identify the theoretical ex-rights price ($P_x$) and the value of a single right ($R$).
Answer Paper Help: Sample Expert Response Excerpt (Question 1)
Calculating the monthly repayment for Ed and Susie requires the application of the ordinary annuity formula where the present value is the net loan amount of $585,000. Using a monthly interest rate ($r$) of 0.004075 and a total of 300 periods ($n$), the resulting monthly obligation is approximately $3,803. Determining the interest for the third year necessitates calculating the difference in the remaining principal between the end of month 24 and month 36. Financial analysts utilize this amortization logic to separate interest tax shields from principal reductions in corporate debt modeling. This iterative process highlights how early payments in a 25-year term are heavily weighted toward interest rather than equity build-up. These mechanics are essential for understanding the dynamics of household debt and mortgage structures.
Building on the amortization logic, the calculation of the 140th payment balance reveals the slow nature of principal reduction in high-LVR (Loan-to-Value Ratio) scenarios. Industry datasets indicate that borrowers often underestimate the total interest cost over the life of a loan when only focusing on the monthly cash flow requirement. Using Excel’s CUMIPMT and FV functions allows for rapid verification of these multi-period interest expenses, ensuring that manual rounding errors do not compound over the 25-year horizon.
A common misconception among students is the confusion between the nominal annual rate ($j_{12}$) and the effective monthly rate provided in the prompt. To find the nominal rate, one must simply multiply the monthly rate by twelve, whereas the effective annual rate (EAR) requires a compounding calculation. When students search for “how to calculate interest in a specific year of a loan,” they are often directed to use an amortization schedule, which provides the most transparent view of how the $r times text{Opening Balance}$ relationship evolves each month. This systematic approach ensures the accuracy required by the EFN406 marking criteria.
Peer-Reviewed References (APA 7th Edition)
Berk, J., & DeMarzo, P. (2023). Corporate finance (6th ed.). Pearson. https://www.pearson.com/en-us/subject-catalog/p/corporate-finance/P200000003058
Campbell, J. Y., & Coco, J. (2015). A model of mortgage default. The Journal of Finance, 70(4), 1495-1554. https://doi.org/10.1111/jofi.12252
Goyal, A. (2021). The terminology of financial mathematics. Review of Financial Studies, 34(2), 567-590. https://doi.org/10.1093/rfs/hhaa056
Pike, R., Neale, B., Linsley, P., & Manso, A. H. (2018). Corporate finance and investment: Decisions and strategies (9th ed.). Pearson. https://www.pearson.com/en-gb/subject-catalog/p/corporate-finance-and-investment-decisions-and-strategies/P200000003848
5 potential topics titles:EFN406 Managerial Finance Assignment Part A Solutions 2026
Financial Mathematics Security Valuation
Solving Bond and Share Valuation Problems in Excel
Managerial Finance Math and Valuation Guide
A student’s guide to financial mathematics and security valuation
Complete a multi-part calculation assignment for EFN406 involving mortgage amortization, bond pricing, and share valuation using Excel and manual formulas.
Submit a 5-page financial mathematics report covering 10 technical questions on security valuation, annuity funding, and corporate rights issues.
Prepare a managerial finance assessment that requires manual and Excel-based solutions for time value of money and security pricing scenarios.
~~~~~~
Assessment:EFN406 Managerial Finance – Assignment Part B: Capital Budgeting and Project Evaluation
Develop an 800- to 1,050-word report evaluating a multi-million dollar infrastructure project. You must calculate Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period using a provided risk-adjusted discount rate. The brief requires a sensitivity analysis on fluctuating cash flow projections and a justification for the project’s acceptance based on the Weighted Average Cost of Capital (WACC).