Comprehensive Project and Financial Management Analysis

This financial management project analyzes various aspects of financial planning and control. It includes the creation of annual purchase and operating expense budgets, along with income projections for a sole proprietorship and an LLC. The assignment delves into tax calculations, make-or-buy decisions based on spare capacity, and the application of flexible budgeting and variance analysis. It also covers cash flow management, including accounts receivable and payable schedules, and provides recommendations for loan repayment strategies. Furthermore, the project evaluates capital investment decisions by comparing the profitability of Project X and Project Y using techniques such as net present value and payback period, ultimately recommending the more financially viable option. The document concludes with a list of relevant academic references.

PROJECT AND FINANCIAL
MANAGEMENT
Submitted to:

BUDGETING
 Annual Purchase budget
Windows
(Amt in $)
Productions Required (2400*12) 28800
ADD: Closing (2400*2) 4800
Less: Opening (Given) 1200
Units to be purchased 32400
Purchase price (unit * $90) 29,16,000$
Annual Purchase Budget

Annual operating expenses budget
(Amt in $) (Amt in $)
Selling Expenses
Advertising 46,080$
Wages shop 1,44,000$
Sales commission 4,60,800$
Vehicle running expenses 30,000$
Delivery truck expenses 60,000$
Shop rent 43,200$
7,84,080$
Distribution expenses
Packaging and freight 3,45,600$
Warehouse rental 60,000$
4,05,600$
Administration expenses
Power 9,600$
Office salaries 2,40,000$
Office rental 1,20,000$
3,69,600$
15,59,280$Total Operating expenses
Annual Operating budget
Windows

BUDGET INCOME FOR SOLE
PROPERITOR
2018
Sales revenue 46,08,000
Closing stock 4,32,000
50,40,000
Direct material 29,16,000
Add: Opening stock 1,08,000
Selling Expenses
Advertising 46,080
Wages shop 1,44,000
Sales commission 4,60,800
Vehicle running expenses 30,000
Delivery truck expenses 60,000
Shop rent 43,200
Distribution expenses
Packaging and freight 3,45,600
Warehouse rental 60,000
Administration expenses
Power 9,600
Office salaries 2,40,000
Office rental 1,20,000
45,83,280
Net Income Before Taxes 4,56,720
Income tax expense 1,41,637.6
3,15,082
Total Expenses
Income from Continuing Operations
Income Statement
Revenue
Total Revenues
Expenses

TAX CALCULATIONS
 Using individual tax rate
 14,000 x 10.5% = 1470
 48,000 x 17.5% = 34,000 x 17.5%
= 5950
 70,000 – 48,000 = 22,000
 456,720 – 70,000 = 386,720 x 33%
= 127,617.60
 141,637.60

BUDGET INCOME FOR LLC
2018
Sales revenue 46,08,000
Closing stock 4,32,000
50,40,000
Direct material 31,32,000
Add: Opening stock1,08,000
Selling Expenses
Advertising 46,080
Wages shop 1,44,000
Sales commission 4,60,800
Vehicle running expenses30,000
Delivery truck expenses60,000
Shop rent 43,200
Distribution expenses
Packaging and freight3,45,600
Warehouse rental 60,000
Administration expenses
Power 9,600
Office salaries 2,40,000
Office rental 1,20,000
47,99,280
Net Income Before Taxes2,40,720
Income tax expense 67,402
1,73,318
Revenue
Total Revenues
Expenses
Total Expenses
Income from Continuing Operations

RECOMMENDATION
 Asif Rahman is the sole proprietor. The
company is in growth phase and this
loss would be overcome by the
company if the company form itself
into LLC.

MAKE OR BUY DECISION
 Spare capacity:
 Company should make the component.
 No spare capacity:
 Company should buy the component.

FLEXIBLE BUDGET
 Variance analysis
This
quarter
This
quarter
This
quarter
Year to
date Year to date Year to date
Budget
($)
Actual
($) Variance
Favour
able/
Advers
Budget
($) Actual ($) Varinace
Favour
able/
Advers
Expenses
Cost of sale 28750 31938 -3188 U 54688 58125 -3437 U
Electricity 1875 2000 -125 U 3750 3666 84 F
General expenses 5563 5979 -416 U 10625 11038 -413 U
Consultancy fee 3125 3125 0 F 6250 6250 0 F
Advertising 5563 5131 432 F 10125 9619 506 F
Wages 15938 17400 -1462 U 31250 33419 -2169 U
Total expenses 60814 65573 -4759 U 116688 122117 -5429 U

 Variance analysis (3450 units)
This
quarter
This
quarter
This
quarter
Year to
date Year to date Year to date
Budget
($)
Actual
($) Variance
Favour
able/
Advers
e
Budget
($) Actual ($) Variance
Favour
able/
Advers
e
Expenses
Cost of sale 35424 31938 3486.11 F 67383 58125 9258.42857 F
Electricity 2310 2000 310.268 F 4621 3666 954.535714 F
General expenses 6854 5979 875.411 F 13092 11038 2053.51786 F
Consultancy fee 3850 3125 725.446 F 7701 6250 1450.89286 F
Advertising 6854 5131 1723.41 F 12475 9619 2856.44643 F
Wages 19638 17400 2237.89 F 38504 33419 5085.46429 F
Total expenses 74932 65573 9358.54 F 143776 122117 21659.2857 F

 Explanation and recommendation
 If a variance is favourable then it simply means
that the variance of the company is in the favour
of the organization and explains that the cost of
the company is even lesser than the expected
cost
 It is highly recommended to David Trading limited
to prepare a flexible budget as a flexible budget
enables the administration to evaluate the
deviation of expected output from actual output

CASH BUDGET
 Accounts receivable cash collection
schedule
Jan Feb March April May June
Total sales 96000 102000 108000 1,26,000$ 1,32,000$ 1,32,000$
Cash received 70% 75,600$ 88,200$ 92,400$
Cash received 15% 15,300$ 16,200$ 18,900$
Cash received 10% 9,600$ 10,200$ 10,800$
Total cash received 1,00,500$ 1,14,600$ 1,22,100$
Accounts receivable cash schedule
For the year 2017