DIABB Maths Rules
*Yearly
Depreciation =   Cost – Salvage Value
                                        
Estimated Life
*Statement
of Investment Cost:
Cost
of Machine               =
Add:
Working Capital      =
Total                                 =
----------------
                                              Statement
Of Cash inflow
| 
                Particulars | 
Year 1 | 
Year 2 | 
Year 3 | 
Year 4 | 
Year 5 | 
| 
Profit
  Before Depreciation & Tax |  |  |  |  |  | 
| 
Less:
  Depreciation |  |  |  |  |  | 
| 
Earnings
  Before Tax |  |  |  |  |  | 
| 
Less:
  Tax % |  |  |  |  |  | 
| 
Earnings
  After Tax |  |  |  |  |  | 
| 
Add:
  Depreciation |  |  |  |  |  | 
| 
Cash
  Before Terminal Cash inflow |  |  |  |  |  | 
| 
Add:
  Salvage Value |  |  |  |  |  | 
| 
Add:
  Working Capital |  |  |  |  |  | 
| 
Net
  Cash Inflow |  |  |  |  |  | 
                                          Calculation
Of Payback Period:
| 
Year | 
Cash Inflow | 
Cumulative Cash Inflow | 
| 
1 |  |  | 
| 
2 |  |  | 
| 
3 |  |  | 
| 
4 |  |  | 
| 
5 |  |  | 
1.
Payback Period: A+ NCO  - C    Here: A= The year in which cumulative cash
Inflow
                           D                         Comes nearer to NCO         
                                                        NCO= Net Cash Outlay
                                                        C= Cumulative Cash Inflow of the
Year A.
                                            D= Cash Inflow of the Year Following
The year A.
2.ARR
(Average rate of Return)= Average EAT           x 100
                                     Average Investment
Averages
EAT= Total  EAT
               Years
Average
Investment= Net Working Capital + Initial Investment+ Salvage Value
                                                            
                   2
3.ROI
(Return On Investment)= Average EAT   
  x100
                                   Total Investment
                           Table For
Calculation Of NPV, PI, NPI, IRR
| 
Year | 
Net
  Cash Inflow | 
DF
  %(A) | 
PV | 
DF%(B) | 
PV | 
| 
1 |  |  |  |  |  | 
| 
2 |  |  |  |  |  | 
| 
3 |  |  |  |  |  | 
| 
4 |  |  |  |  |  | 
| 
5 |  |  |  |  |  | 
Total
PV of Cash inflow=
Less:
Investment            =
NPV(Net
Present Value)=
4.NPV= Total PV Of Cash Inflow –
NCO       10. NCB= Total CFAT/NO: Of
Years
5.PI=      TPV   
 x 100                                       6. NPI=
PI - 100
         PV
of NCO
7.PV OF PBP= A+  PV of NCO – C           8. PBR=       1    x100
                                                    D                                                   
PBP
9.IRR:
IRR=A+       C       x (B-A) 
Here:    A=Lower Discounting Rate=
                   C-D                                B=Higher
Discounting Rate=
                                                         C= NPV of Lower Discount
Factor=
                                                         D= NPV of Higher Discount Factor=
For
Positive NPV= NPV Negative Hole DF% Komate Hobe Minimum 10%
Since
The Project PI<1 , Hence it is not wise to select the project.
PI>1
= Accept
NPV
(+) = Acceptable
TPV>NCO
Acceptable
                                                                
Company Name
                       Statement Of Cost/ Cost
Of Goods Manufactured/Cost of Goods Sold
                                               
For The Year Ended 30 June,2013
| 
Particulars | 
Tk | 
Tk | 
Tk | 
| 
Raw
  Materials: 
Opening  Raw Materials 
Add: Purchase
  Raw Materials 
Add: Carriage
  Inwards/Freight In 
Total Cost Of
  Purchase 
Less: Purchase
  Return And Allowance 
Less: Purchase
  Discount 
Net Cash Of
  Purchase 
Raw Materials
  Available For Use 
Less: Ending
  Raw Materials 
Raw Materials
  Consumed 
Add: Direct
  Labor/ Wages 
Add: Other
  Direct Expense(Factory wages, Production Wages, Manufacturing Wages) 
Prime
  Cost 
Add:
  Factory Overhead: 
Indirect ‡jLv me ai‡Yi  Expense 
Factory/ Work Gi mv‡_ †jLv  Expenses 
Depreciation
  For Plant, Machine, Tools, Equipment 
Coal, Gas,
  Water 
Drawing Office
  Salary 
Works Welfare
  Expense 
Insurance/Premium
  For Factory 
Total
  Manufacturing / Factory Overhead 
Less: Sale Of
  Scrap 
Total
  Manufacturing Cost/ Factory Cost/ Works Cost 
Add: Beginning
  Work in Process 
Total Cost Of
  Input 
Less: Ending
  Work In Process 
Cost
  Of Goods Manufacture / Production Cost 
Add: Beginning
  Finished Goods Inventory 
Cost Of Goods
  Available For Sale 
Less: Ending
  Finished Goods Inventory 
Cost
  Of Goods Sold 
Add:
  Administrative Expense(Office Salary, Rent Exp, Insurance Exp, Utilities Exp,
  Supplies Exp, Depreciation Exp-Office Furniture) 
Add: Selling
  Expense: ( Advertising Exp, Carriage Out, Freight Out, Delivery Exp, Salesman
  Salary, Depreciation On Store Equipment) 
Total
  cost 
Add:  Profit 
Sales |  |  |  | 
                                               Name
Of The Company
                                 Statement Of
the Cash Flow (Indirect Method)
                                               
For The Year Ended 2013
| 
Particulars | 
Tk | 
Tk | 
| 
Net Income: |  | 
*** | 
| 
(1)Cash Follow From Operating Activities |  |  | 
| 
Add: Non Cash
  Exp. | 
*** |  | 
| 
Depreciation
  Exp. ( Building, Equipment) | 
*** |  | 
| 
Amortization
  Exp.(Patent) | 
*** |  | 
| 
Amortization Of
  Discount On Bonds Payable | 
*** |  | 
| 
Add: Decrease
  In Accounts Receivable | 
*** |  | 
| 
         Decrease In Merchandize Inventory | 
*** |  | 
| 
         Decrease In Prepaid Expense | 
*** |  | 
| 
         Increase In Accounts Payable | 
*** |  | 
| 
         Increase In Accrued Expense Payable | 
*** |  | 
| 
         Loss On Sale Of Any Fixed Assets
  (Investment, Equipment) | 
*** |  | 
| 
Less: Increase
  In Accounts Receivable | 
(***) |  | 
| 
          Increase In Merchandise Inventory | 
(***) |  | 
| 
          Increase In Prepaid Expense | 
(***) |  | 
| 
          Decrease In Account Payable | 
(***) |  | 
| 
          Decrease In Accrued Expense Payable | 
(***) |  | 
| 
          Gain Of Sale of any fixed Assets
  (Investment, Equipment) | 
(***) |  | 
| 
          Income Tax Paid  | 
(***) |  | 
| 
Net Cash Provided By Operating Activities: |  | 
*** | 
| 
(2)Cash Follow From Investing  Activities: |  |  | 
| 
Add: Cash
  Received From Sale Of Trading Securities | 
*** |  | 
| 
          Cash Received From Sale Of Any
  Fixed Assets ( Equipment) | 
*** |  | 
| 
 Less: Cash Purchase Of Any Fixed Assets | 
(***) |  | 
| 
Net Cash Provided By Investing  Activities: |  | 
*** | 
| 
(3)Cash Follow From Financing  Activities: |  |  | 
| 
Add: Cash
  Received From Issuance Of Bonds Payable | 
*** |  | 
| 
          Cash Received From Issuance Of
  Short Term Notes Payable | 
*** |  | 
| 
          Cash Received From Issuance Of
  Common Stock | 
*** |  | 
| 
          Cash Received From Issuance Of
  Share/ Stock | 
*** |  | 
| 
Less: Payment
  Of Cash Dividend | 
(***) |  | 
| 
         Cash Paid For Treasurer Stock | 
(***) |  | 
| 
         Cash Paid For Redemption Of Bonds | 
(***) |  | 
| 
         Cash Paid For Retirement Of Bonds | 
(***) |  | 
| 
Net Cash Provided By Financing   Activities: |  | 
*** | 
| 
Net Changes In
  Cash During The Year |  | 
*** | 
| 
Add: Beginning
  Balance Of Cash |  | 
*** | 
| 
Ending Balance Of Cash: |  | 
*** | 
|  |  |  | 
Comments
Post a Comment