PROJECT WORK GUIDELINES FOR PROJECT WORK IN ACCOUNTANCY (ISSUED BY CBSE) ‘The Board has introduced Project Work in Accounting for class Xl in the optional Part B ‘Financial Statement Analysis. It is expected that the Project Work will help the students in developing the skills to comprehend, analyse and interpret accounting data of the business firms and make it meaningful for taking business decisions UNIT-WISE WEIGHTAGE OF MARKS Project Work Duration: 1 Hour 30 Minutes Marks: 20 Marks Unit 1: Project File “4 Marks - As per Requirement (given below) Unit 2 : Written Test 12 Marks - One Hour Unit 3 : Viva Voce 4 Marks As Per Requirement (given below) UNIT 1: PROJECT FILE (4 Marks) Objectives + (i) To enable a student to complete the accounting process in real business situations and apply the tools of analysis as per the syllabus for a comprehensive project. (i) To develop the competence of reading accounting data from quarterly or half yearly or annual reports of business firms and interpreting the information on the basis of given guidelines to present the desirable Information in required format in the Project File for specific projects. Guidelines for Teachers : During the academic session, the students will work on at least three types of projects out of which one will be comprehensive in nature. The comprehensive projects will involve the students from the initial stage of accounting to the preparation and analysis of financial statements. The data provided or the project statement will be as close as the real life situations. The project statement should cover all important aspects like investments, financing, operating, adjustments to final accounts, etc. in a condensed form. The situations given in these problems will require a student to derive meaningful information for taking decisions for purpose of investment, expansion, financing, etc. Two projects will be of specific nature using atleast one tool of analysis in each. The data for these will be drawn mainly from quarterly or half yearly or annual reports of corporate sector. Student will analyse the Information given in the financial statements as follows. (a) Performance of Segments keeping in mind their three parameters Revenue, Net Profit and Capital Employed of companies on quarterly or half yearly or annual basis. This is widely published and reported by the companies. It can be picked up either from the newspapers or from the websites of the companies. {b) Comparison of Revenue, Net Profit and Earning Per Share (EPS) on quarterly or half yearly or annual basis with the help of comparative or common size statements ‘The Projects given in these guidelines are on sample areas of business activities like Segment Reporting, ete, The teachers and students are free to explore more such areas of business activities for specific projects. There are four tools of analysis given in the syllabus for the analysis of Financial Statements, namely (i) Comparative Statement, (ii) Common Size Statements, (ii) Ratios and (iv) Cash Flow Statement. Any one or more of these tools are to be used to derive conclusions. No project is to be prepared on the tools, but these Accountancy ~ 12 0tools are to be used to achieve the object of the project. For instance, there will not be any project on the ‘Ratios’ as such, but ratios will be used in the development of the project to reach a conclusion. Scope : For the purpose of Project Work, the following ratios will be included : Liquidity Ratios: Current Ratio, Liquidity Ratio. Solvency Ratios: Debt to Equity; Total Assets to Debt, Proprietary Ratio. Activity Ratios Inventory Turnover, Debtors Turnover, Payables Turnover, Working Capital Turnover, Fixed Assets Turnover, Current Assets Turnover. Profitability Ratio : Gross Profit Ratio, Operating Ratio, Net Profit Ratio, Return on Investment, Earning Per Share ~ Price Earnings Ratio. A few projects have been given in detail a the end of the guidelines for practice. The student is expected to analyze the facts, and present the information in a meaningful manner for interpretation. Teachers are expected to discuss these problems thoroughly with the students and encourage them to come out with solutions. They are also expected to collect the quarterly or half yearly or annual Segment reports and Revenue and Net Profit reports of companies from newspapers or from the websites of the companies and formulate their ‘own problems for Project Work UNIT 1: PROJECT FILE (4 Marks) Students will prepare a Project File to record their work related to the problems attempted by them in the following format 1. First page ofthe file should describe ttle of work, identity of student, school, and the teacher concerned. 2. Index to indicate columns for title of work, page no., date, teacher’s remarks and signature. 3. The Format for Project Work will be 3 Statement of the problem / Name of the Project 2 Objectives > Period of Study 2 Source material 2 Tools of Analysis used 2 Processing and Tabulation of data 2. Diagrammatic / graphic presentation-pie-diagrammes, bar diagrammes and graphs > Derivations, Interpretation and Conclusion 3. Assumptions (if any) Project File should be neatly handwritten and presentable with page numbers. Each step of the solution needs to be highlighted. Conclusions drawn should be placed in boxes at the end. Evaluation Guidelines for the Examiner While evaluating the Project File, marks are to be awarded out of four, based on 2 Content > Coverage 2 Presentation 3. Interpretation and Conclusion 2 Originality and Quality of work Accountancy ~ 12 @UNIT 2: WRITTEN TEST (12 Marks) TIME: 1 Hour Objectives = (i) To give them exposure to analyse the financial statements of business firms and help them to derive meaningful Information there form, (a7 To know how effectively the students can derive conclusions and express them. Guidelines for Teachers : Teachers will discuss with students the sample questions for this test and develop question papers for the purpose in their house examinations. Guidelines for Examiners : Students willbe given 2 application-oriented problems of 6 marks each covering the tools for analysis of financial statements. The question paper will be set in consultation with the school teacher. No question similar to ‘the question given in the 3 hour question paper of the Board, should be asked here. Only such questions, relating to financial statements of companies should be asked which encourage thinking on practical lines. The external examiner will discuss with the internal examiner all the projects completed during the year and set the questions accordingly. On the day of the examination both should come prepared with at least 10 questions each. Both the internal and external examiners must agree on the nature and scope of questions asked. It must be ensured that multiple sets of papers are prepared. Marks will be awarded on the steps taken, data identified and solution arrived at. UNIT 3 : VIVA VOCE (4 Marks) Objectives : (0) To assess whether the student has understood topic covered and is able to express. (if To assess whether the project fle presented by the student is genuine and prepared by him only. Guidelines for Teachers : (i) During the course of the academic year, the teacher must give thorough practice to the students on ‘Viva Voce’ examination on each aspect of the project report and file. (ii) During all internal examinations, ‘Viva Voce’ examination should form an integral part of the practical examination. (ii) Wherever possible, the teacher may invite a colleague/expert from another school for asking questions. This will rehearse the students for the final examination. Guidelines for Examiners : ‘The work done by students in Project File will form the basis of asking questions. The external examiner will ask 2-3 questions to test the authenticity of the work done in the files. Marks will be awarded out of 4 in consultation with the school teacher, Viva Questions : Should relate only to the project = (i) To check the authenticity of the work and (if) To check that the student understands the idea behind the Project Accountane °PROFORMA OF PROJECT FILEPRESENTATION OF PROJECT WORK ‘After completing the project work, itis to be presented for evaluation in a file. A proforma of Project File is given below PROJECT FILE 1. Title of Work 2. Name of the Student 3. Class, A, Section ne 5. Roll No. allotted by CBSE 6. Name of the Teacher 7. Name of the School 8 Session ACKNOWL EDGEMENT | would like to convey my heartfelt thanks to Mr/Mrs,/Ms. -s my Accountancy teacher who always gave valuable suggestions and guidance during the completion of this project. He/She has been a source of inspiration during the completion of my project work. He/She helped me to understand and remember important details of the project that | would have otherwise lost. My project has been a success only because of his/her guidance. Name of the Student Roll no. allotted by CBSE Accountancy ~ 12CERTIFICATE This is to certify that Mr/Ms of Class Of eesnnnsnnennees Public School has completed his/her project file under my supervision, He/She has taken proper care and shown utmost sincerity in completion of this project. | certify that this project is upto my expectation and as per the guidelines issued by CBSE. Mr /Mrs./Ms. (PG. Commerce/Head of Commerce Department) (Signature) INDEX St. | Title of the Project Work Page Source | Remarks | Teacher's No. no. Signature 1. | Comprehensive Project xx self Specific Project 1 x Economic Times 3. | Specific Project i! Xx Economic Times Accountancy ~ 12 ©)Note : Components of Formulae for Accounting Ratio: These are used as per financial statements (or final accounts) of sole trader, partnership and company. The distinction is given below Tn case of Sole Trader/Partnership ‘In Case of Company Components of formula of accounting ratios as per| Components of formula of accounting ratios as per ‘Trading and Profit and Loss Account and Balance | Statement of Profit and Loss and Balance Sheet Sheet 1. Short-term Investment 1. Current Investment 2. Stock 2. Inventory 3. Debtors/Bills Receivable 3. Trade Receivables 4. Cash in Hand / Cash at Bank 4. Cash and Cash Equivalents 5. Creditors + Bills Payables 5. Trade Payables 6. Long-term Assets 6. Non-Current Assets 7. Long-term Liabilities 7. Non-Current Liabilities 8 Long-term Investment 8, Non-Current Investment 9. Total Sales 9. Total Revenue from Operations 10. Cost of Goods Sold/Sales 10. Cost of Revenue from Operations 11. Cash Sales 11, Cash Revenue from Operations 12, Credit Sales 12. Credit Revenue from Operations Accountancy ~ 12 ”Comprehensive Project 1 1. Name of the Project : A Study of the business of M/s Alpana Kids Garments 2. Objectives of the Project : (i) To know whether M/s Alpana Kids Garments is a success or a failure (il) To know whether the Bank will give loan for their business. 3. Period of Study : One year ending 31st March 2015 4, Analystical tools used : Necessary Accounting Ratios 5. Source Material : Project Statement PROJECT STATEMENT : M/s Alpana Kids Garments Mr. Kanha had 1,000 shares of ICICI Ltd. of € 100 each. In March, 2014, he sold his shares @ € 980 each. With this amount, he decided to set up a business of Kid Garments on 1 April, 2014 under the name of M/S Alpana Kids Garments. He decided that all transactions should be made through bank and deposited the whole money in Dena Bank. He purchased a running factory of Kid Garments consisting of Factory Land and Building 4,00,000, Plant and Machinery & 3,50,000, Furniture € 50,000, Stock & 90,000 but agreed to pay % 9,50,000 as purchase consideration. He later approached his banker for a loan to meet the working capital requirement. Bank advanced loan amounting to € 4,00,000 @ 10% p.a. He purchased a Laptop for € 30,000. His transactions for the year ending 31st March, 2015 were as follows : z ‘Total Purchases (¥ 8,30,000 in credit) 12,40,000 Total Sales (€ 15,25,000 in credit) 20,50,000 Wages 2,30,000 Carriage inwards 20,500 Power and Lighting 15,500 Salary of Staff and Manager 1,25,000 Postage and Call 4,200 Printing and Stationery 3,800 Advertising 16,700 Insurance Premium 12,100 Conveyance 13,200 Cash received from Debtors 12,10,000 10% Fixed Deposit in Dena Bank 5,00,000 Paid to Creditors 6,50,000 Receivable received from debtors 4,00,000 Bills accepted in favour of creditors 80,000 Drawings during the year @ & 5,000 p.m. 60,000 You are required to (1) Journalise these transactions and post them into ledger accounts and prepare a Trial Balance. (2) Prepare Trading and Profit and Loss Account for the year ended 31st March, 2015 and Balance Sheet as at that date after considering the following adjustments: A ceountaney - 12 ®Adjustments : (A) Closing stock & 1,10,000 (ii) Depreciate Land and Building by 5%, Plant and Machinery and Furniture by 10% and Computer by 25%. (iif) Salary Outstanding & 8,000 and wages outstanding % 15,000. (iv) Insurance premium Prepaid © 1,200. (v) Accrued Interest & 25,000 {3) Comment on the profitability and short-term solvency of the firm when similar firms earn Gross Profit @ 20% and Net Profit @ 10%. (4) Also compute Interest Coverage Ratio to see whether the firm can meet its interest burden regularly in future. (5) In future M/s Alpana Kids Garments would be in need of more funds for expansion purpose. For this ‘they are planning to approach the bank for further loan. Suggest on the basis of the ratios calculated above, whether bank can grant more loan to this firm ? Sol. In the Books of Alpana Kid Garments a Journal Date Parialars te] oe | eR 21s prt or | Bank Ave be 9.80.00 Toccpital Ne +,80,000 (For commenced business) Apri ot. [Land and Bulaing fe De 400,000 Plant and Machinery Ale or 350,000, Furniture A/c o 50,000 Stock A/e or 90,000 Goodwill Ae (al. Fig) or 60,000 To Bank Ale +9,50,000 (for sundry assets taken over for €9,50,000 and payment made forthe same) Bank Ale De 400,000 To 10% Bank Loan A/c 400,000 {Forbankloan taken) Office Equipment Ale De 30,000 ‘To Bank Ale 30,000 (For laptop purchased in cash) ross. [Purchases Ae De 1240,000 ToBank Ale 410,000 ToCrediors Ae 830,000 (For goads purchased in cath and on cre) Bank Ale De 5,235,000 Debtors Ne De 15,25,000, ToSales Ale 20,50,000 (For goods sold on cash and credit) wages Ale De 2,30,000 Cerviage inwards Afe or 20,500 Power and Lighting A/c or 415,500 Salaries Ne oe 125,000 Postage and Call A/c o ‘4200 Printing and Stationery Ale be 3800 Advertising A/c or 16,700 Insurance Premium Ae or 12,100 Conveyance Ne or 13,200 “To Bank A/e 441,000 Accountane °wank we : “eiieo00 ~ To Debtors Ne (Forcath received from debtors) Creditors Ale Be 650,000 To ank Ale 650,000 (For amount paid to creditors) 10% Fred Deposit NE co 5,00,000 ToBank Ne 3,00,000 (Foramount transferred from current ae to fixed deposit a) Bil Receivable Ale Or 1,00,000 ToDebtors 140,000 (Forbils received from debtors) Creditors Ale Be 20000 ‘ToBills Payable A/c 30,000 (For acceptance given to creditors) Drawings Ale 60,000 To Bank Ale 60,000 (For drawings made during year) Grand Total '3651000_| 86,81,000 Ledger Accounts Dr Bank A/c cr. Dae Partulars Le | ome Partie aad 201 2018 Apri ot | To Capital Ne 980,000 | Apri 01 | ay Land & Building Ae 400,000 4,00,000 aprit ot | 8y Plant & Machinery A/c 350,000 To 10% Bank Loan Ae 5,25,000| gon ox | BY Furniture Nec 50,000 sao.n0 | on Oy | By Stock re 30,000 To Sales Alc Pe 8 | By Goodwill A/c 60,000 ‘April 02 | gy office Equipment Ale 30,000 To Debtors Ale by Purchases Ale 410,000 By Wages A/c 2,30,000 By Carriage AVe 20,500 By Power & Lighting Ale 15,500 By Salary Ae 125,000 By Postage & Call Ne 4.200 By Printing & Stationery Ae 3800 By Advertising Ale 16,700 By Insurance A/c 32,100 By Conveyance A/c 33200 By Creditors Ale 650,000 By 10% Fixed Deposit Ale 500,000 8y Drawings Ae 60,000 By Balance c/a 74,000 31,5000 31,35,000 2015 ‘apa or | To Balance 6/4 74,000 Dr. Capital A/c cr. = Partials TT ® | ome Pariulars TS 201s 2014 Mar. 31 | To Balance c/é 90,000 | pri ot | 8y Bank Ae 2015 Apri 1 | ay Balance b/d 80,000 Accountancy ~ 12 0)Dr. Land and Building A/c cr Date Partials Te] ® | ome Partials iealaae! 2018 2015 ‘april ox | 10 Bank Ale 400,000 | war 31 | By Balance oft 400,000 2015 ‘april 02 | to Balance b/d 400,000 Dr. Plant and Machinery A/c cr. Date Particulars a Paris ieee 2018 2015, ‘ort o2 | To Bank Ale TSOBOO] Mar. 31 | By Balance c/ 330000 2015 ‘sprit 02 | To Balance b/d 3,50,000 Dr. Furniture A/c cr. Date Partai TA] ® | ome Parr m=] 2o1e 201s ‘april 02 | 10 Bank Ale SODOo] Mar. 31 | By Balance c/a 30,0007 2015, April 02 | To Balance b/6 50,000 Dr. Stock A/e cr. Date Particulars TL ® | ome Paris m= ore 2015, ‘sprit 02 | To Bank Alc BODO] Mar. 31 | By Balance c/a 30,000 2015 ‘april 02 | To Balance b/d 90,000 Dr. Goodwill A/c cr Date Partials [© [ome Pariulars orale! 2014 2015 ‘april 02 | 10 Bank Aje GODOT] Mar. 31 | By Balance c/a Eo) 2015 ‘april 02 | to Balance b/d 60,000 Dr. 10% Bank Loan A/e cr. Date Particulars TT ® [ome Paris ieee 2015 row ‘Mar 31 | To Balance o/d “FOO DGO] April on | By Bank Ale 00000 aos ‘pail 01 [By Balance b/d 400,000 Dr. Office Equipment A/c cr Date Partai TL ® | ome Parr m=] 2014 2015 ‘april 02 | To Bank Ale 30,000] Marc 31 | By Balance e/a 30,000 2015, April 01 | To Balance b/d 30,000 Dr. Purchases A/c cr Date Particulars TT ® | bate Partials Vesa 21a [To Bank Ale “430,000 | 2015 To Creditors Ale 8,30,000 | Mar 31 | By Trading Ale 140,000 7240000) 12,40,000 Accountancy ~ 12 oyDr. Creditors A/c . Date Paris Le | ose Paros mI 2018-15 | To Bills Payable Ale ‘0,000 | 2014 | By Purchases Ae 830,000 To Bank Ale 6.50,000 To Balance ef 3,00,000 830,000 830,000 2015 ‘apr ot | By Balance b/d 100,000 Dr. Debtors A/c cr Date Part TL ® | one Paria me 2018 | To Sales Ale 1525000 [2015 | By Bank ae 32,10,00, by Bills Receivable Ale 100,000 Mar. 31. | By Balance c/a 2,15,000 1525000, 1525000, 201s ‘apa or | To Balance 6/4 215,000 Dr. Sales A/c cr. Date Particulars aE] ® | ome Partials irae 201s pore | y Bank Are 525,000 Mar 31 | To Tading Ae 20;50,000 By Debtors afe 15,25,000, 20,50,000 2050000 Dr. Wages A/c cr. Date Parte mL _® | oate Paros net eee 2oue 2015; To Bank Ale 2,30.000 | Mar. 31 | ey Trading Ale 2,30,000 Dr. Carriage Inwards A/c , Dae Paria TL * | one Paria ie 2018 2015 To Bank Afe 20500 | Mar 31_| y Trading Ale 20,500 Dr. Power and Lighting A/c cr. Date Particulars aT ®| ome Particles a 71s 2015; To Bank Ale 15,500| mar. 31_| by Tading Ae 15,500 Dr. Salaries A/c cr. Dae Partai w]e] one Parte mm 2018 125,000 | 2015 1 Bank Ale ‘Mar 31_| By Prost and Loss Ne 1,25,000 Dr. Postage and Call A/c . Date Paris eT _® | ate Paros a 2018 “3200 | 2015 To Bank A/c Mar. 31 | By Prot and Loss Ae 4,200 Dr. Printing and Stationery A/e cr. Date Particulars a a Parcs irae 201 2015 To Bank Ale 3,800] mar 31_[ by Profit and toss Ae 3,800 A ceountaney - 12 2)Dr. Advertising A/c cr Date Particulars bes] aeaicae tio Particulars ieiaael owe 2015, ‘To Bank Ale 16,700 | Mar. 31 | By Profit and Loss A/c 16,700 Dr. Insurance Premium A/c cr. Dae Parseulars Te] ® ome Pariulare m=] 2018 201s To Bank Ale 12,200 | Mar. 31 | By Profit and Loss A/c 12,100 Dr. Conveyance A/c cr. Date Particulars TL ® | bate Panui m=] 2018 2015, To Bank A/c 13,200 | Mar 31 | By Profit and Loss A/c 13,200 Dr. 10% Fixed Deposit A/c cr. Bate Parsulars [ebm Partials TF zoe 20s To Bank Ae SOODGD] mar 31 | By Balance b/d SoU 201s ‘april o1_[To Balance b/d 5,00,000 Dr. Bills Receivable A/c cr. Date Particulars TL ® | bate Paroles vee 2015 201s | To Debtors Ae TOOBOO] Mar. 31 | By Balance c/a 00,000, Aprit ox | 10 Balance b/4 7100,000 Dr. Bills Payable A/c cr. Date Particulars a Paris eae! 2015 ‘Mar 31 | 10 Balance cfd BODOG] 2018 | wy crecitors Ae BO,000. ‘April 02 | By Balance b/d mma) Dr. Drawings A/c cr. Bate Parseulars Tm] e | ome Pariulare m=] zoe 20s ‘orl 02 | To Bank Ale GODOT] Mar 31 | By Balance e/a EXO) To Balance b/d anal ‘Trial Balance 1s ot 31st March, 2015 Sen Name of ledger Accounts De Balance ] Gr Balance z z 1 | ani 7a00| — 2 | cantar ~ | 380000 3. | Land and Busing 490000) - 4 | ant and machinery 350000] - 5. | Furniture soon) - 6._| stock sooo] - Accountancy ~ 12 413)7. | 6oodwit ‘60,000 = 8, | 10% Bank Loan - | 400.000 9. | office Equipment 30,000 - 10, | Purchases 12,40,000 - 11, | Creditors = | 1,00.000 12, | debtors 215,000 - 13, | Sales = | 2050000 14, | Wages 2,30,000 . 15. | carriage 20,500 - 16. | Powerand lighting 15500 . 17. | Salaries 3.25,000 . 18, | Postage and Call 4200 - 19, | Printing and stationery 3,800 5 20. | Advertising 16,700 a 21, | insurance Premium 12,100 . 22. | Conveyance 13,200 . 23, | 108 Fixed Deposit 5,00,000 a 24, | Bills Receivable 100,000 ] 25, | Bills Payable - 80,000 26. | Drawings 160,000 7 '36,10,000 | _36,10,000 (2) Preparation of Trading and Profit and Loss Account and Balance Sheet ‘Trading and Profit & Loss A/e Dr. for the year ending March 31, 2015 cr Particulars = Particulars = “To Opening Stock ‘20,000 | By Sales 20,50,000 To Purchases 12,40,000 | By Closing Stock 1110,000 ‘To Wages 2,30,000 ‘Add: Outstanding Wages 15,000 | 245,000 To Carriage inward 20500 ‘To Power and tighting 15,500 ‘To Gross Profit c/d 5.49,000 ‘otal | 23,60,000, ‘otal | 23,60,000 ‘TosSlaries 11.25,000 By Gross Profit b/d 549,000 ‘Add : Outstanding Salaries 8,000 | 1,33,000 | By Accrued interest 25,000 ‘To Postage and Call 4,200 ‘To Printing and Stationery 3.800 To Advertising 16,700 To insurance Premium 32,100 Less Prepaid Insurance Premium (1,200) } 10.900 ‘To Conveyance 13,200 ‘To Depreciation Land and Building 20,000 Plant and Machinery 35,000 Furniture 5,000 Office Equipment 7.500 ‘To Outstanding interest on Bank Loan 40,000 ‘To Net Profit transferred to Capital Ale 2,98,700 ‘otal | 5,74,000, Total Accountancy ~ 12 4)Balance Sheet 2 at March 21, 2015 bites z Assets z ‘ils Payable 30,000 | Bank 7,000 Creditors 100,000 | ils Receivable 1400.00 urstanding Wages 15,000 | debtors 215,000 Outstanding Salaries 8,000 | closing Stock 410,000 BankLoan Prepaid Insurance Premium 11200 ‘Add: Outstanding interest 440,000 | accrued intrest 25,000 copia Land and Buiaing 400,000 pening capal 980,000 ess: Depreciation (20,000) | 3,80,000 ‘Add Net Profit 284,700 Plant and Machinery ‘3330;000 72,68,700, ess: Depreciation (35,000) | 3:1,000, L635 Drawings (60,000) | 12,04,700 | rurniture 50,000, ess: Depreciation 15,000) | 45,000 office Equipment 30,000, tess: Depreciation 700] 22,500 Sood =| 60.000 10% Fixed Deposit 500,000 ‘out | 7547700 roval [7547,700 (3) Comment on the profitability and short-term solvency of the firm : (0 Calculation of Profitability Ratios Gross Profit Ratio = Gross Profit , 499 = %5,49,000 1 Net Sales € 20,50,000 "1 let Profit Ratio = Net Profit 2 2,84,700 peace Net Sales “10° g 20,50,000 coe Cost of Goods Sold + Operating Expenses Operating Ratio i : Net Sales 100 =... % where, (a) Cost of Goods Sold Sales ~ Gross Profit % 20,50,000 ~ 5,49,000 = & 15,01,000 (b) Operating Expenses = (Administrative and Selling and Distribution Expenses) = 1,33,000 + 4,200 + 3,800 + 16,700 + 10,900 + 13,200 + 20,000 + 35,000 + 5,000 + 7,500 + 40,000 = & 2,89,300 (15,01,000 + 2,89, 300) , 499 = 37,90,300 499 - 0,50, 0 00 = 30,50, 000 *100 = 87.33% (if) Calculation of Short Term Solvency Ratios. Operating Ratio _Cutrent Assets _ Current abilities where, Current Assets = Bank-+ 8/R + Debtors + Closing Stock + Prepaid Expenses + Accrued Interest 74,000 + 100,000 + 2,15,000 + 1,10,000 + 1,200 + 25,000 = 5,25,200 Current Liabilities 8/? + Creditors + Outstanding Wages + Outstanding Salary + Outstanding (0) Current Ratio Interest £80,000 + 1,00,000 + 15,000 + 8,000 + 40,000 = 2,43,000, 5,25,200 Cash outflow has increased by 122.95%. Accountancy ~ 12 4s)Aud Bu Particulars x x Net Profit before Interest and Tax 530,000 6,00,000 i) nol = Net Prof before interest and Tar. 499 20.000. a £00,000. 00 «: : Capital Employed 25,00,000 "10° 30,00,000 * 100 = 20% Net Profi after tax 265,000 300,000 (i) Net Profit Ratio = Net Profit afer 2, 199 285.000. 100 = 10% 0.000 00 Fevenve from Operations 36,50,000 35,06,000 * 100° 10.3% B Limited is earning better profit margin yet the return on capital employed of A Ltd. is better. It is making better and efficient use of its financial resources. Net credit revenue from operations ‘Average trade receivables _ __Number of days na year Trade Receivables Turnover Ratio |. Trade Receivables Turnover Ratio Debt Collection Period (in days) Xia. Yuta. Trade Receivables, = ___#7,00,000 ___ %7,00,000 €10,00,000 ___ @ 10,00,000 Turnover Ratio ©, 20,000 + & 80,000 - %1,00,000 | ®2,80,000 + € 1,20,000 ¥ 2,00,000 2 2 Times Times Debt Collection Period (in | 365 days. 365 days aa = 2 82¥8. = 52 days (approx) SEAS 73 days ‘After analysing the above ratios, it is clear that debt collection department of X Ltd. is not working efficiently as compared Y Ltd. Itis evident from the data given below : Particular xual vied z z Days Granted as 30 ‘Actual Days for Collection 52 2B Delayed Collection Tay = Days Saved 2 Tas Accountane)| a PRACTICAL PAPER Time Allowed : 1 Hour] [Maximum Marks :12 1. Amit Ltd. and Sumit Ltd. require bank loan for 3 years to be repaid over a period of 3 years. Following information is given to you Raton ‘Amita. Sumit ‘arvent Ratio Every 2 Liquid Ratio 13:1 aa Debt Equity Ratio nal asa Interest Coverage Ratio astimes| 10 8mee Suppose you are a bank officer and both the companies have approached the same bank. Find (i) Ifyou wish to give loan to only one company, which will it be ? (id If you could grant loan to both companies, would you prefer to advance loan to both the companies. If yes, why? 4 2. Payment of rent or any expense is an operating outflow. The following information is given for two years 2013-14 and 2014-15, Find out whether this outflow has increased or decreased in the year 2014-15 in relative terms. 4 nto) Parsee 2013-34 @) [2013-24 ®) Rent outstanding inthe beginning 000 [12,000 Rent oustanding a the end x00] 4000 Prepaid Rent in the betinning 8000} 7,000 Prepaid Rent at the end 7000} 9,000 Rent charged to statement of Profit andloss s;00| 45,000 3, Shyam and Sunder went to Stock Exchange. Syam purchased shares worth 6,000 and sold for ® 6,600. Sunder purchased shares for @ 5,000 and sold them for & 5,600. Who is a better investor and why? 2 4, A businessman starts his business with € 10,00,000. He borrows & 20 lakh @ 18% p.a. from the bank. He bought ‘a machine for & 8,00,000 and paid rent ¥ 24,000 in advance for two months. He bought goods of & 3,60,000 for ‘cash. He sold goods for & 4,00,000 for cash, He also pald interest on loan for two months, Find out cash flows on account of various activities. 2 SOLUTIONS 4. Conclusion : (i) The current ratio of Amit Ltd is 2.6 : 1 and that of Sumit Ltd is 2 : 1 against the standard ratio of 2:1. Short- term solvency position of both the companies is sound though Amit Ltd is better placed. (if) The liquid ratio of Amit Ltd is 1.3 : 1 and that of Sumit Ltd is 1 : 1 against the standard ratio of 1: 1. Both companies are good but Amit Ltd is better placed. Accountancy = 12. 4)(ii), Debt equity ratio of Amit Ltdis 1 : 1 and that of Sumit Ltd is 1.3: 1 against the standard of 2:1. Both companies prefer to rely less on borrowed fund but still Amit Ltd is better placed (iv) Interest coverage ratio of Amit Ltd is 15 times in relation to 10 times in case of Sumit Lid Both are good ‘companies, Decision : (i) IFloan is given to only one company, it should be given to Amit Ltd as itis comparatively better in relation to Sumit Lt (7) However, bank can provide loan to both the companies as financial position of both the companies is on sound footing, 2. To know the flow of cash due to rent, rent account is to be prepared for both years: Rent Account Dr. for the year ended 31st March 2014 cr. Prius ‘Amount Prius ‘Amount @ @ To Balance b/s ‘8,000 | 6y Balance b/a ‘8,000 (Prepaid in begining) {Outstanding inthe beginning) ToBank Ne 41,000 | By statement of Profit & Loss 5,000 (Rent paid during the year) {ent charged uring the year) ToBalanee ef 1,0 | by Balance ef 7900 (Outstanding atthe end) {Prepaid atthe end) 60,000 60,000 Rent Account Dr. for the year ended 31st March 2015 cr. Paras z Partials z To Balance b/s 7,00 | By Balance b/a 11,000 (Prepaid in begining) (Outstanding inthe beginning) To bankale 56,000 | By statement of Profit & Loss 45,000 (Rent pad during the year) (Rent charged during the year) ‘To balance ed +4000 | By Balance cfd 9,000 (Outstanding atthe end) (Prepaid at the end) 55,000 65,000 Rent paid during the pervious year = © 41,000, Rent paid during the current year = 54,000 Thus, increase in cash outflow due to rent during the current yearis _€ 13,000 3. Profit % of Shyam = Profit % of Sunder = 600 5000 * 10° S00 100 = 10% 100 = 2% Since the profit % of Mr, Sunder is more than Mr. Shyam, thus it can be concluded that Sunder isa better investor. Accountane as) -12 74. Cash Flow from Various Activities (0) Cash flow from Operoting Activities z Purchase of goods for cash (3,60,000) Payment of Rent (24,000) Sale of goods for cash 4,00,000 Cash flow from operating Activities 16,000 (id. Cosh low from Investing Activities Purchase of Machinery & 8,00,000) Cash used in Investing Activities 18,00,000) (i) Cosh low from Financing Actes: —— Capital contribution % 10,00,000 loan from Bank % 20,00,000 Interest paid on Bank loan for 2 months (60,000) (20,00,000 28 x 2 100 * 12 Cash flow from financing activities % 29,40,000 Accountancy ~ 12 (60)Ee PRACTICAL PAPER Time Allowed : 1 Hour] (Maximum Marks :12 1, Following table gives the actual and standard ratio of Crown India Ltd. for the year 2014-15: SNe Partials Aewat | Sandard 1 | Curent Assets/Current bites : a 2. | Cost of Revenue from Opertionsinventory : A 3. | Net credit Revenue from Operations/Trade Recehables « 3B 4, | net Prot before interest and tax/Captal Employed 40 Critically examine the above mentioned ratios. 3 2. From the following particulars regarding credit sales in 2013-2014 and 2014-2015, Is it correct to say that cash inflow from collection from debtors has improved in the year 2014-2015? a wia2018 | 20182015 z z ‘Opening balance of trade recsvables sooo] Closing balance of trade receivables 24000] 60,000, Credit Revenue from operations 240,000 480,000, Discount allowed 000] 6,000 Bad debts 2000} 4,000 Returns Inward 500] 3,000 What is the amount of change in cash flows? 3 3. The following comparative percentages are computed from the financial statements of two companies, XYZ Ltd and POR Utd, XYZ Ltd. PR Ltd, (0) Net income to Revenue from Operations 2% 9% Revenue from operations 80,000 95,000 Net Income to capital Employed 15% 12% Opening Receivables 10,000 8,000 Closing Receivables 12,000 8,000 Which company appears to be more successful? Give reasons, 3 4 If Credit purchases are 36,00,000 and cash purchases are 25% of total purchases. Find out the cash flow from operating activities when rent paid is € 1,50,000 and commission received & 2,50,000. 3 SOLUTIONS (i) The current ratio (Le., Current Assets/Current Liabilities) of the company is much higher than the standard, Company is comfortable in making timely payment to Its creditors. However, it seems that itis not using its funds effectively. It must invest the surplus fund in investments so that it may earn interest/dividend on idle fund. (i) The inventory turnover ratio (Cost of revenue from operations) is also higher than the standard. It indicates that company is rapidly turning over its inventory. 2 Accountane 1)(iii) Trade Receivables turnover ratio (Net Credit Revenue from Operations/Trade Receivables) is also higher than the standard ratio. It implies that company is efficient in collecting its debt. (iv) Return on investment (Net Profit/Capital employed) of the company is lower than the standard ratio. t means. that company is not using capital employed effectively Suggestion : ‘The company should try to push its sales so that turnover ratios may improve. Higher sales will yield higher ret profit: It will also improve the return on capital employed. 2. Cash flow from Debtors for the year ended 2013-2014 : Dr. ‘Trade Receivables A/c cr, Partials ‘amount Particulars ‘amount ® @ To Balance 6/4 50,000 By Cash Ae (Bale) 2,54,000 ‘ToCredit Revenue from operations 240,000 | By Discount allowed +4000 By Bad debts 2,000 By Return inwards 000 By Balance fa 24,000 790,000 2,90,000 Cash flow from Debtors for the year ended 2014-2015 Dr ‘Trade Receivables A/c cr. Parieuae mount Paria Amount @ ® Tosalance 6/8 74;000 | By Cash ATE (Bal Fe) 26,00 “oCredit Revenue from operations 480,000 | By Discount alowed 6,000 By Bad debts 4000 By Return inwards 8,000 By Balance cfs 0,000 5908000 508,000 Increase in cash flow during the year = & 4,26,000 ~& 2,54,000 = 1,72,000 3. XYZ Ltd is earning more on its Revenue as compared to POR Ltd. Rate of Return on Investment of XYZ Ltd is more than POR Ltd. This indicates that the overall performance of XYZ Ltd is better than POR Ltd. XYZ Ltd is more successful as itis utilizing its invest ment more efficiently than POR Ltd. 4. Credit Purchases © 36,00,000 Cash Purchases are 25% of total purchases, Let Total Purchases = 2 x Cash Purchases = 25% of x Credit Purchases = x~ 25% of &x Accountancy = 12. (2)75 36,00,000 = 5p, x= € 48,00,000 Cash Purchase 5% of & 48,00,000, Cash Purchase = @ 12,00,000 Cash flow from operating Activities Cash Purchases Payment of Rent A/c Commission Received Cash used in operating Activities 2s Accountancy 63) 12 z (22,00,000) (2,50,000) 2,50,000 (21,00,000)