Question
How healthy is the current budget and what is the profitability projection index showing? I need to make an appropriate recommendation to senior management based
How healthy is the current budget and what is the profitability projection index showing?
I need to make an appropriate recommendation to senior management based on these findings.
Income: |
|
|
Sales | $8,650,000 | Cooking implements and appliances |
Investment income | $1,567,000 | Real estate investment income and rental of office space |
Cost of goods sold (COGS) | ($4,690,000) | Cost of provision of goods, purchase of stock, distribution |
Gross profit | $5,527,000 | Gross profit |
Expenses: |
|
|
Wages, salaries and on costs | $2,567,890 | Wages, salaries, superannuation, work cover insurance, payroll tax |
Communication expenses | $42,000 | Telephone, ISP costs, IT support |
Marketing | $920,000 | Cost of staff travel and associated costs for sales, etc. |
Premises expenses | $1,000,000 | Rent, electricity, maintenance, cleaning |
Insurance | $120,000 | Liability insurance |
Depreciation and amortisation | $177,569 | Computers and capital equipment that is depreciated |
Office supplies | $54,068 | Printing and stationery, postage, amenities |
Training | $32,187 | Sales training: leadership, WHS, ethical/legal training |
Total expenses | $4,913,714 |
|
Net profit | $613,286 | Net income before tax |
Profitability index over three years | |||
Profitability index (PI) = | Present value (PV) of future cash flows | ||
Present value (PV) of initial investment | |||
PI>1 indicates project should be undertaken: | FY 2017 | FY 2018 | FY 2019 |
Cash flow from operations (minus ongoing operational costs associated with e-commerce such as additional staffing) | $200,000 | $500,000 | $800,000 |
Present value of future cash flows (discounted future cash flows with respect to opportunity cost, inflation) | $180,000 + $420,000 + $600,000 = $1,200,000 | ||
Present value of initial investment | $861,000 | ||
Profitability index | 1.39 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started