Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial ACCT2

Authors: Norman H. Godwin, C. Wayne Alderman

2nd edition

9781285632544, 1111530769, 1285632540, 978-1111530761

Students also viewed these Accounting questions