Michael Hermawan Yuwono MGMT6346 Ba10 Utp
Michael Hermawan Yuwono MGMT6346 Ba10 Utp
Michael Hermawan Yuwono MGMT6346 Ba10 Utp
BALANCE SHEET
2015 2016
Current Assets
Cash $ 50,000 $ 50,000
Account Receivable $ 200,000 $ 300,000
Inventory $ 450,000 $ 570,000
Total current assets $ 700,000 $ 920,000
Fixed assets, net $ 300,000 $ 380,000
Total Assets $ 1,000,000 $ 1,300,000
INCOME STATEMENT
2015 2016
Net Sales $ 1,300,000 $ 1,600,000
Costs of Goods Sold $ 780,000 $ 960,000
Gross Profit $ 520,000 $ 640,000
Marketing $ 130,000 $ 160,000
General&Administrative $ 150,000 $ 150,000
Depreciation $ 40,000 $ 55,000
EBIT $ 200,000 $ 275,000
Interest $ 45,000 $ 55,000
Earnings before taxes $ 155,000 $ 220,000
Income taxes (40% rate) $ 62,000 $ 88,000
Net Income $ 93,000 $ 132,000
1. Operating Activity
Net Income $ 132,000
Depreciation $ 55,000
Increase in Receivables $ -100,000
Increase in Inventories $ -120,000
Increase in Payables $ 50,000
Increase in Accrued $ 20,000
Net Cash Flow in Operations $ 37,000
2. Investing Activity
Increase in fixed assets $ -80,000
3. Financing Activity
Increase in other long-term liabilities $ 150,000
Cash Dividend Paid $ -107,000
Net from Financing Activities $ 43,000
Net Change excluding other account $ -
Beginning cash and marketable securities $ 50,000
Ending Cash and marketable securities $ 50,000
4. Arus Kas masuk yang paling banyak diperoleh Munich Export Corporation adalah dari kegiatan financing.
Arus Kas keluar Munich Export Corporation adalah di kegiatan investasi (investing).
Besarnya jumlah cash burn per bulan adala $ -3,583 Rumusnya : Annuel Net Cash Burn adalah $
BALANCE SHEETS
2015
Current Assets
Cash $ 50,000
Account Receivable $ 200,000
Inventory $ 450,000
Total current assets $ 700,000
Fixed assets, net $ 300,000
Total assets $ 1,000,000
Account payable $ 130,000
Accruals $ 50,000
Bank Loan $ 90,000
Total current liabilities $ 270,000
Long-term debt $ 300,000
Common stock* $ 350,000
Retained earnings $ 80,000
Total liabilities and equity $ 1,000,000
INCOME STATEMENT
$ 2,015
Net sales $ 1,300,000
Cost of goods sold $ 780,000
Gross profit $ 520,000
Marketing $ 130,000
General & administrative $ 150,000
Depreciation $ 40,000
EBIT $ 200,000
Interest $ 45,000
Earning before taxes $ 155,000
Income taxes (40% rate) $ 62,000
Net income $ 93,000
Cash dividens $0
A. Hitunglah Liquidity ratio yang meliputi current rasio, quick ratio, dan NWC to total assets ratio
B. Hitunglah Leverage ratio yang meliputi total debt to total assets ratio, equity multiplier, debt to equity ratio, current liabi
D. Hitunglah Efficiency ratio yang meliputi sales to total assets ratio, operating return on assets, return on assets,
KOMPONEN 2015
Current Ratio 2.59
Quick Ratio 0.93
NWC to Total Assets Ratio (%) 0.43
Total Debt to total Assets Ratio 0.48
Equity Multiplier 2.86
Debt to Equity Ratio 1.371
Interest Coverage Ratio 0.56
Current Liabilities to Toal Debt 5.33
Fixed Charges Coverage 0.44
Gross Profit Margin 0.4
Operating Profit Margin 0.15
Net Profit Margin 0.07
NOPAT Margin 0.09
Sales to total Asset Ratio 1.30
Operating Return On Assets 0.20
Return on Assets Ratio 0.09
ROA Model 0.09
ROE Model 0.27
Return On Equity 0.27
2016 2017
$ 40,000 $ 10,000
$ 260,000 $ 360,000
$ 500,000 $ 600,000
$ 800,000 $ 970,000
$ 400,000 $ 500,000
$ 1,200,000 $ 1,470,000
$ 170,000 $ 180,000
$ 70,000 $ 80,000
$ 90,000 $ 184,000
$ 330,000 $ 444,000
$ 400,000 $ 550,000
$ 350,000 $ 350,000
$ 120,000 $ 126,000
$ 1,200,000 $ 1,470,000
$ 2,016 $ 2,017
$ 1,500,000 $ 1,800,000
$ 900,000 $ 1,260,000
$ 600,000 $ 540,000
$ 150,000 $ 200,000
$ 150,000 $ 200,000
$ 53,000 $ 60,000
$ 247,000 $ 80,000
$ 57,000 $ 70,000
$ 190,000 $ 10,000
$ 76,000 $ 4,000
$ 114,000 $ 6,000
$ 74,000 $ -
2016 2017
$ 800,000 $ 970,000 Yang terdapat pada current assets adalah cash + receivables + inventory
$ 330,000 $ 444,000 Yang terdapat pada current liabilities adalah payables + accruals + bank loan
2.42 2.18 Rumusnya adalah Current Assets/ Current Liabilities
2016 2017
$ 800,000 $ 970,000 Yang terdapat pada current assets adalah cash + receivables + inventory
$ 500,000 $ 600,000
$ 330,000 $ 444,000 Yang terdapat pada current liabilities adalah payables + accruals + bank loan
0.91 0.83 Rumusnya adalah (Current Assets - Inventories) / Current Liabilities
2016 2017
$ 800,000 $ 970,000 Yang terdapat pada current assets adalah cash + receivables + inventory
$ 330,000 $ 444,000 Yang terdapat pada current liabilities adalah payables + accruals + bank loan
$ 1,200,000 $ 1,470,000 yang terdapat pada total assets adalah cash + account receivable + inventory + To
0.39 0.36 Rumusnya adalah (Current Assets - Current Liabilities) / Total Assets
ier, debt to equity ratio, current liabilities to total debt ratio, interest coverage, dan fixed charges coverage.
2016 2017
$ 640,000 $ 810,000 Yang terdapat pad total debt adalah payables + accruals + long-term loan
$ 1,200,000 $ 1,470,000 yang terdapat pada total assets adalah cash + account receivable + inventory
0.53 0.55 Rumusnya adalah Total Debt/Total Assets
2016 2017
$ 1,200,000 $ 1,470,000 yang terdapat pada total assets adalah cash + account receivable + inventory
$ 350,000 $ 350,000
3.43 4.20 Rumusnya : Total Assets / Owner's Equity
2016 2017
$ 640,000 $ 810,000
$ 350,000 $ 350,000
1.83 2.31 Rumusnya : Total debt / Equity
2016 2017
$ 330,000 $ 444,000
$ 640,000 $ 810,000
0.52 0.55 Rumusnya : Current Liabilities/Total Debt
2016 2017
$ 300,000 $ 140,000 Rumus : Depreciation + EBIT
$ 57,000 $ 70,000
5.26 2.00 Rumusnya : EBITDA/Interest
Sebanyak 5X Sebanyak 2X
2016 2017
$ 300,000 $ 140,000
$ 723,666.67 $ 986,666.67
0.41 0.14 Rumusnya : EBITDA / Interest + (Debt Payments / 60%)
fit margin, net profit margin, dan NOPAT margin
2016 2017
$ 600,000 $ 540,000
$ 1,500,000 $ 1,800,000
0.4 0.3 Rumusnya : (Net Sales-COGS)/Net Sales
2016 2017
$ 247,000 $ 80,000
$ 1,500,000 $ 1,800,000
0.16 0.04 Rumusnya : EBIT/Net Sales
2016 2017
$ 114,000 $ 6,000
$ 1,500,000 $ 1,800,000
0.08 0.003 Rumusnya : Net Income/Net Sales
2016 2017
$ 148,200 $ 48,000 Tax Rate adalah 40 %
$ 1,500,000 $ 1,800,000
0.10 0.03 Rumusnya : (EBIT X (1-TAX RATE)) / Net Sales
eturn on assets, return on assets, ROA Model, return on equity, dan ROE Model
2016 2017
$ 1,500,000 $ 1,800,000
$ 1,200,000 $ 1,470,000
1.25 1.22 Rumusnya : Net Sales/Total Assets
2016 2017
$ 247,000 $ 80,000
$ 1,200,000 $ 1,470,000
0.21 0.05 Rumusnya : EBIT/Total Assets
2016 2017
$ 114,000 $ 6,000
$ 1,200,000 $ 1,470,000
0.10 0.004 Rumusnya : Net Income/Total Assets
2016 2017
0.08 0.003
1.25 1.22
0.10 0.004 Rumusnya : (Net Income/Net Sales) x (Net Sales/Total Assets)
2016 2017
0.08 0.00
1.25 1.22
3.43 4.20
0.33 0.02 Rumusnya : Net Profitt Margin x Sales to total Assets Ratio x Equity Multip
2016 2017
$ 114,000 $ 6,000
$ 350,000 $ 350,000
0.33 0.02 Rumusnya : Net Income/Owner's Equity
2016 2017
2.42 2.18
0.91 0.83
0.39 0.36
0.53 0.55
3.43 4.20
1.829 2.314
0.52 0.55
5.26 2.00
0.41 0.14
0.4 0.3
0.16 0.04
0.08 0.003
0.10 0.03
1.25 1.22
0.21 0.05
0.10 0.004
0.10 0.004
0.33 0.02
0.33 0.02
eivables + inventory
es + accruals + bank loan
eivables + inventory
eivables + inventory
es + accruals + bank loan
nt receivable + inventory + Total Current Assets + Fixed Assets,net `
s) / Total Assets
September $ 80,000
Oktober $ 100,000
November $ 130,000
December $ 160,000
Januari 2018 $ 190,000
A Buatlah sales schedule, purchase schedule, dan wages & commissions schedule untuk September – Desember 201
B Buatlah cash budget untuk bulan September – Desember 2017 dan jelaskan bagaimana sebuah forecasting memp
C Buatlah proyeksi bulanan laporan laba rugi (income statement) untuk periode September – Desember 2017.
D Buatlah proyeksi bulanan neraca (balance sheet) untuk periode September – Desember 2017.
E Buatlah proyeksi bulanan laporan arus kas (statement of cash flow) untuk periode September – Desember 2017.
A SALES SCHEDULE
AUGUST SEPTEMBER
Schedule 1 : Sales Forecast $ 92,000 $ 80,000
Credit Sales,40 % $ 36,800 $ 32,000
Credit Sales, 60% $ 55,200 $ 48,000
PURCHASES SCHEDULE
AUGUST SEPTEMBER
Schedule 3 : Purchases
Ending Inventory $ 90,800 $ 102,000
Costs of Goods Sold $ 64,400 $ 56,000
Total needed $ 155,200 $ 158,000
Beginning Inventory $ (97,520) $ (90,800)
Purchases $ 57,680 $ 67,200
B CASH BUDGET
AUGUST SEPTEMBER
Beginning cash balance $ 29,487 $ 37,562
Cash Receipts
Collection from customers $ 101,200 $ 84,800
Total cash available for needs before financing $ 130,687 $ 122,362
Cash disbursements
Merchandise $ 62,650 $ 62,440
Wages and commissions $ 21,275 $ 18,650
Miscellaneous expenses $ 4,600 $ 4,000
Rent $ 4,600 $ 4,600
Truck purchase $ - $ -
Total disbursements $ 93,125 $ 89,690
Minimum cash balance desired $ 23,000 $ 23,000
Total cash needed $ 116,125 $ 112,690
Excess of total cash $ 14,562 $ 9,672
Financing
New borrowing $ - $ -
Repayments $ - $ -
Loan balance $ - $ -
Interest $ - $ -
Total effects of financing $ - $ -
Cash balance $ 37,562 $ 32,672
C Income Statements
SEPTEMBER OKTOBER
Sales $ 80,000 $ 100,000
(-) Costs of goods sold $ (56,000) $ (70,000)
Gross margin $ 24,000 $ 30,000
Operating expenses
(-)Wages and commissions $ (17,750) $ (20,750)
(-)Rent $ (4,600) $ (4,600)
(-)Miscellaneous expenses $ (4,000) $ (5,000)
(-) Insurance $ (460) $ (460)
(-)Depreciation $ (1,150) $ (1,150)
(-)Total operating expenses $ (27,960) $ (31,960)
(-)Income from operations $ (3,960) $ (1,960)
(-)Interest expense $ - $ -
Net Income $ (3,960) $ (1,960)
D Balance Sheets
Current Assets
SEPTEMBER OKTOBER
Cash $ 32,672 $ 23,000
Accounts receivale $ 32,000 $ 40,000
Merchandise inventory $ 102,000 $ 118,800
Prepaid insurance $ 1,380 $ 920
Total Current Assets $ 168,052 $ 182,720
Plant
Equipment, fixtures, and others $ 92,000 $ 92,000
Accumulated depreciation $ (36,340) $ (37,490)
Net property, plant, and equipment $ 55,660 $ 54,510
Total Assets $ 223,712 $ 237,230
Current Liabilities
Accounts payable $ 33,600 $ 43,400
Accrued wages and commissions payable $ 8,875 $ 10,375
Loan $ - $ 4,178
Total current liabilities $ 42,475 $ 57,953
Owners’ Equity $ 181,237 $ 179,277
Total liabilities and equity $ 223,712 $ 237,230
SCHEDULE
OKTOBER NOVEMBER DESEMBER
$ 100,000 $ 130,000 $ 160,000
$ 40,000 $ 52,000 $ 64,000
$ 60,000 $ 78,000 $ 96,000
ES SCHEDULE
OKTOBER NOVEMBER DESEMBER
BUDGET
OKTOBER NOVEMBER DESEMBER
$ 32,672 $ 23,000 $ 23,000
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ 13,463 $ 10,665 $ 28,306
$ 13,463 $ 10,665 $ 28,306
$ - $ 0 $ (14,562)
$ 23,000 $ 23,000 $ 116,234
$ 23,000 $ 23,000 $ 101,672
haan PDC tahun 2017 sebagai berikut:
Keterangan :
JANUARI SEPTEMBER TO JANUARI
$ 190,000 $ 660,000
$ 76,000 $ 264,000 Rumusnya : 40% dari Sales Forecast
$ 114,000 $ 396,000 Rumusnya : 60% dari Sales Forecast
$ 114,000 $ 396,000
$ 64,000 $ 224,800
$ 178,000 $ 620,800
Keterangan :
SEPTEMBER TO DESEMBER
$ 508,800 Rumusnya : Sales Forecast Bulan Depan x 0,7 x 0,8 + 46.000 ( 46.000 adalah had
$ 329,000 Rumusnya : Sales Forecast x 0,7
$ 837,800
$ (447,200) Rumusnya : melihat ending inventory bulan lalu
$ 390,600
Keterangan :
SEPTEMBER TO DESEMBER
$ 116,234 Rumusnya : Cash Balance Bulan Lalu
$ 485,340
$ 92,000
$ 577,340
$ (18,306) Rumusnya : Total cash available for needs before financing - total cash needed
$ 28,306
$ 50,124
$ 327
$ 27,978
$ 101,672 Rumusnya : Excess of total cash + minimum cash balance desired bulan tersebut +
Rumusnya
Sale Forecast Bulan Tersebut
COGS bulan tersebut
Sales Forecast - COGS
Rumusnya
Rumusnya
Net Income Bulan tersebut
on
t
ayable
ncing
ALPHAONE SOFTWARE CORPORATION
BALANCE SHEET
2016
Current Assets
Cash $ 20,000
Account Receivable $ 250,000
Inventory $ 350,000
Total current assets $ 620,000
Fixed assets, net $ 480,000
Total Assets $ 1,100,000
INCOME STATEMENT
2016
Net Sales $ 1,500,000
Costs of Goods Sold $ 850,000
Gross Profit $ 650,000
Marketing $ 250,000
General&Administrative $ 206,000
Depreciation $ 50,000
EBIT $ 144,000
Interest $ 84,000
Earnings before taxes $ 69,000
Income taxes (40% rate) $ 24,000
Net Income $ 36,000
A. Hitunglah besarnya laba operasional setelah dipotong pajak (net operating profit after taxes atau NOPAT)
NOPAT = Earnings before interest and tax * (1 – Tax rate) = $144,000 * (1 – 40%) = $ 144.000 * 60% = $ 8
B. Hitunglah biaya modal rata – rata tertimbang (weighted average cost of capital atau WACC)
C. Tentukanlah besanya biaya modal finansial (cost of financial capital) yang digunakan perusahaan Alpha One
D. Hitunglah estimasi nilai tambah ekonomi (economic value added atau EVA). Lakukanlah analisis apakah per
al atau WACC)
Lakukanlah analisis apakah perusahaan Alpha One Software membangun atau menghancurkan nilai ekonominya di tahun 2016
konominya di tahun 2016