Premium Essay

Working Capital Management Project

In:

Submitted By serdyz
Words 1530
Pages 7
Working Capital Management: Analysis Project #1 Fall, 2012 Dr. Echevarria Cameron School of Business

Working Capital Management Project The WCM project is an exercise using an enhanced cash budget to make changes to operating parameters in order to observe the impact on the pro forma income and balance sheet statements. The exercise uses an MS Excel spreadsheet. There are several management strategy options that will be simulated in order to gauge the results on operating cash flows and profitability. You task will be to analyze each option and determine which options will improve profitability.

Your analyses will be written using a MS-Word document. Copy and paste from the spread sheet only the 6 [green] cells containing the Changes in Operating Income, Net Profit Margin, and Net Income. Label the word document as follows: LASTNAME_WCM.doc and email assignment to davidpe@charter.net. The assignment is due by midnight (Sunday), September 30, 2012.

Background The Reliant Electrical Systems, Inc (RES) was started in 1967 to produce standby home power generators in the 12 to 15 Kilo-Watt peak output range (100 - 125 Amps at 120 volts AC). RES sells the generators to electrical equipment retailers and to home improvement outlets such as Home Depot and Lowes. In addition, a number of units are sold to small construction companies as well as state and federal agencies. The main facility is a 150,000 square foot building located in Richardson, Texas. This building houses company offices and the production facility. The company has 190 production employees, 16 production supervisors, and additional 26 workers and supervisors providing quality control (QC), warehousing (shipping and receiving), and production/inventory control (Factory Overhead). RES has 10 sales representatives covering the US, Canada, and Mexico. 18 persons work in the company's

Similar Documents

Premium Essay

Working Capital Management Integrated Project

...RUNNING HEAD: Working Capital Management Integrated Project Assignment 2: Working Capital Management Claudio Cordon Strayer University March 11th, 2012 A1. The sales staff believes RES can increase the FOB price by $125.00 per unit. This increase in price is expected to decrease sales by 2.5%. [Hint: Increase B3 by $125. Enter -2.5 in cell B66.] The cash balance increased to $8,602,692 at the end of 2012 based on the projection of increasing the price by $125 even though sales decreased by 2.5%. Tho OI increased from 9.7M to 12.9M. The change in price will move NPM from 4% to 6.39% and NI from 3.4M to5.5M. This can be a good solution for the company to be successful in 2012. |Chg in OI |Performance Measures |Current |With Changes |Change Magnitude | | $3,273,175 |Current Ratio |4.93 |5.52 |0.59 | |NPM |Quick Ratio |3.74 |4.32 |0.59 | |6.39% |Defensive Interval |81.57 |93.79 |12.22 | |Chg in NI |Times Interest Earned |2.82 |3.98 |1.17 | |$2,169,025 |Gross Profit Margin |30.39%...

Words: 1241 - Pages: 5

Premium Essay

Working Capital Management

...Project Report (Submitted for the Degree of B.Com. Honours in Accounting & Finance / under West Bengal State University, Barasat) Title of the Project WORKING CAPITAL MANGEMENT IN MARUTI SUZUKI INDIA.LTD Submitted by Name of the Candidate: TANUMOY ROY Registration No. : 13611131114020870 OF 2011-12 Name of the College: RBC EVENING COLLEGE College Roll No: 21 Supervised by Name of the Supervisor MR RANJIT KUMAR DUTTA Name of the College: RBC EVENING COLLEGE Month & Year of Submission FEB 2014 ACKNOWLEDGEMENT I would like to thank our head of the department (HOD) Mr. Ranjit Kumar Dutta, for giving necessary support during the course. Chapter No. | Particulars | Page No. | 1. | INTRODUCTION | 4-7 | 2. | AUTOMOBILE INDUSTRY SCENARIO IN INDIA | 8 | 3. | PRESENTATION OF DATA, ANALYSIS, FINDING | 9-11 | 4. | CONCLUSION,RECOMMENDATION,LIMITATION | 12 | 5. | BIBLOGRAPHY AND REFERANCES | 13 | 6. | SUPERVISER CERTIFICATE | 14 | 7. | STUDENT DECLARATION | 15 | CONTENTS INTRODUCTION 1.1CONCEPT OF WORKING CAPITAL The term working capital is used to mean that proportion of working capital of a business which is employed in short Term or current operations. There are two type of working capital: gross and net. Gross working capital is the sum total of all current asset, while net working capital is the difference between current asset and current liabilities. IMPORTANCE OF WORKING...

Words: 2150 - Pages: 9

Premium Essay

Finance

...The project mainly focuses in detail the Financial Ratios and also understanding of the working capital management of IRCTC. This report will analysis and describe different ratios and how it manages its working capital. “It is meaningless to financially analyse a company without understanding the context and environment in which it operates”. As IRCTC has its monopoly in Indian Railways, so we will take a close look to intra firm analysis. A ratio is an arithmetical relationship between two figures. Financial ratio analysis is a study of ratios between various items or groups of items in financial statements. Ratios can be classified according to statements mainly they are profit and loss ratios or income statement ratios, balance sheet ratios or position statement ratios, mixed ratio or inter statement ratios The ratios are calculated with the help of Annual report of IRCTC provided by the company; the data of last five financial years has been used for that. The project begins with the discussion about the scenario of Indian Railway and role of IRCTC in that. The project then describes the main concept- Ratios and their analysis by determining that why the ratios have changed, which can be due to the change in the accounting policies without a material change in the firm’s performance. The focus of the project then shifts to Working capital which is concerned with the problems that arise in attempting to manage current assets, the current liabilities and the interrelationship...

Words: 523 - Pages: 3

Premium Essay

Working Capital Internship Report

...STUDY ON “WORKING CAPITAL MANAGEMENT “ AT DILIP MARETRIAL HANDLING EQUIPMENT BY SHARATH KUMAR CE 1NZ13MBA35 Submitted to VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELAGAUM In partial fulfillment of requirement for the award of degree of...

Words: 2060 - Pages: 9

Premium Essay

Kec Project Report

...A Project Study Report On Training undertaken at KEC INTERNATIONAL LTD. Titled “Improvement of Working Capital Management by Bringing Efficiency in Billing Process” Submitted in partial fulfillment for the award of the degree of Bachelor of Business Administration In Lieu of Paper 306 Under The Supervision Of Submitted by:- Mr. P.C.Janghir Sugandha Sethia BBA III Yr 2011-2012 BIYANI GROUP OF COLLEGE, JAIPUR UNIVERSITY OF RAJASTHAN CERTIFICATE BY PROJECT GUIDE This is to certify that Ms.Sugandha Sethia student of BBA part III of Biyani Girls College,Jaipur has prepared this project entitled “Improvement of Working Capital Management by Bringing Efficiency in Billing Process” under my supervision. She has prepared report on the basis basis of training...

Words: 10626 - Pages: 43

Premium Essay

Pdf, Docx, Doc

...PROJECT REPORT (Submitted for the degree of B.com Honours in Accounting & Finance under CalcuttaUniversity) ON WORKING CAPITAL MANAGEMENT SUBMITTED BY Name of the Candidate: Registration No. : Roll No. : 0498 Name of the College: Bhawanipur Education Society College Name of University: Calcutta University Submitted on: February 2013 SUPERVISED BY Name of the Supervisor: Name of the College: Annexure- I Supervisor's Certificate This is to certify that Ms. a student of B.Com. Honours in Accounting & Finance ofBHAWANIPUR EDUCATION SOCIETY COLLEGE under the University of Calcutta has worked under mysupervision and guidance for her Project Work and prepared a Project Report with the title “WORKING CAPITAL MANAGEMENT ” which she is submitting, is her genuine and original work to the best of my knowledge. Place: Kolkata Prof. Date: February, 2013 . Annexure- II Student's Declaration I hereby declare that the Project Work with the title “WORKING CAPITAL MANAGEMENT”submitted by me for the partial fulfilment of the degree of B.Com. Honours in Accounting & Finance under the University of Calcutta is my original work and has not been submitted earlier to any other University /Institution for the fulfilment of the requirement for any course of study. I also declare that no chapter of this...

Words: 2773 - Pages: 12

Premium Essay

Financial Analysis

...Financial Analysis & Management Assignments 1. Discuss the extent to which the legal and professional regulatory framework of accounting ensures that corporate reports provide reliable, relevant, objective, and comparable information to users. 2. Critically evaluate the importance of discounted cash flow techniques in investment decisions. Illustrate your answer with your examples. 3. Discuss the relative importance profitability and liquidity for the survival of a business and explain how the working capital can be managed to minimise the risk of liquidity problems. Shahrzad Parhizgar Student Number: B0229JTJT1112 February 2013 Lecturer:PalanAmbikai Word Count: 2980 Financial Analysis & Management Assignments February 1, 2013 Table of Content LEGAL & PROFESSIONAL REGULATORY FRAMEWORKS ENSURING RELIABLE, RELEVANT, OBJECTIVE, AND COMPARABLE DATA ........................................................................................................................................ 3 INTRODUCTION ....................................................................................................................................................... 3 FINANCIAL INFORMATION USERS ................................................................................................................................ 3 LEGAL AND PROFESSIONAL REGULATORY FRAMEWORKS ................................................................................................. 4 FINANCIAL REPORTS...

Words: 4115 - Pages: 17

Premium Essay

Challanges in Banking Sector

...OPEN LEARNING PROGRAMME DEPARTMENT OF ACCOUNTING AND FINANCE UNIT CODE: BAC 502: UNIT TITLE: FINANCIAL MANAGEMENT Course Lecturer: F. Abdul LESSON ONE INTRODUCTION 1.1. What is Financial Management Financial management can be defined as the management of the finances of an organisation in order to achieve the financial objectives of the organization. The usual assumption in financial management for the private sector is that the objectives for the company is to maximize shareholders wealth. 1.2. Financial Planning The financial manager will need to plan to ensure that enough funding is available at the right time to meet the needs of the organisation for short, medium and long-term capital. a) b) 1.3. In the short-term, funds may be needed to pay for purchases of inventory, or to smooth out changes in receivables, payables and cash: the financial manager is here ensuring that working capital requirements are met. In the medium or long term, the organisation may have planned purchase of fixed assets such as plant and equipment, for which the financial manager must ensure that funding is available. Financial Management decisions The financial management decisions relate to investment, financing and dividends. The management of risk must also be considered. Investments in assets must be financed somehow. Financial management is also concerned with the management of short-term funds and with how funds can be raised over the long term. The retention of profits is a financing...

Words: 6418 - Pages: 26

Premium Essay

Saq's Finance Smu

...MB0045 Financial Management | Unit 1 Financial Management | Self Assessment Questions Fill in the blanks: 1. What has changed the profile of Indian finance managers? 2. Finance management is considered a branch of knowledge with focus on the __________.3. Under perfect competition, allocation of resources shall be based on the goal of ________. 4. _______ is based on cash flows. 5. _________ consider time value of money. 6. What are the main goals of financial management? 7. ________ lead to investment in real assets. 8. _____ relate to the acquisition of funds at the least cost. 9. Formulation of inventory policy is an important element of _______. 10. Obtaining finance is an important function of _________. 11. What are the two critical issues to be considered under investment decisions? 12. Define rate of return. 13. The most important decision made by a finance manager is ________. Answers to Self Assessment Questions 1. Liberalisation and globalisation of Indian economy 2.procurement of funds 3. Profit maximisation. 4. Wealth maximisation 5. Wealth maximisation 6. Profit Maximisation and Wealth Maximisation 7. Investment decisions. 8. Financing decisions 9. Liquidity 10. Treasurers 11. The two critical issues are – evaluation of expected profitability of the new investment rate of return required on the project 12. Rate of return is normally defined as the hurdle rate or cut-off rate or opportunity cost of the capital 13. Dividend decision | Unit 2 Financial...

Words: 3902 - Pages: 16

Premium Essay

Finacial Mangment Quetion and Answer

...Multiple choices: 1. The approach focused mainly on the financial problems of corporate enterprise A). Ignored routine problems 2. These are those shares, which can be redeemed or repaid to the holders after a lapse of the stipulated period A).Redeemable preference shares 3. This type of risk arise from changes in environmental regulations, zoning requirements, fees, licenses and most frequently taxes. A). Political risk 4. It is the cost of capital that is expected to raise funds to finance a capital budget or investment proposal A). Future cost 5. This concept is helpful in formulating a sound & economical capital structure for a firm A). Designing optimal corporate capital structure 6. It is the minimum required rate of return needed to justify the use of capital A). Firms point 7. It arises when there is a conflict of interest among owners, debenture holders and the management A). Agency costs 8. Some guidelines on shares & debentures issued by the government that are very important for the constitution of the capital structure are A). Legal requirement 9. It is that portion of an investments total risk that results from change in the financial integrity of the investment A). Default risk 10. _____________ measure the systematic risk of a security that cannot be avoided through Diversification A).Beta Part Two: 1. What is Annuity kind of cash flow? A).An annuity is stream of equal cash flows. Annuities involve calculations based upon the regular periodic...

Words: 895 - Pages: 4

Premium Essay

Working Capital Management - Lanco

...CHAPTER-I INTRODUCTION 1.1 MEANING OF WORKING CAPITAL “Working Capital is the Life-Blood and Controlling Nerve Center of a business” Working capital (abbreviated WC) is a financial metric which represents operating liquidity available to a business, organization or other entity, including governmental entity. Along with fixed assets such as plant and equipment, working capital is considered a part of operating capital. Net working capital is calculated as current assets minus current liabilities. It is a derivation of working capital that is commonly used in valuation techniques such as DCFs (Discounted cash flows). If current assets are less than current liabilities, an entity has a working capital deficiency, also called a working capital deficit. A company can be endowed with assets and profitability but short of liquidity if its assets cannot readily be converted into cash. Positive working capital is required to ensure that a firm is able to continue its operations and that it has sufficient funds to satisfy both maturing short-term debt and upcoming operational expenses. The management of working capital involves managing inventories, accounts receivable and payable, and cash. Current assets and current liabilities include three accounts which are of special importance. These accounts represent the areas of the business where managers have the most direct impact:  Accounts receivable (current asset)  Inventory (current assets),  Accounts payable (current liability) ...

Words: 11017 - Pages: 45

Premium Essay

Working Capital Managemnet

...2013 Project on “Working Capital” Sumit Singh Registration No:-016-1121-0250-10 Roll No: - 301-0063 B-com (Honours), 3rd year Syma Prasad College 1 [Type the author name] 1/1/2013 DECLARATION I am Sumit Singh Student of SYMA PRASAD COLLEGE Of B-com( Honours) 3rd Year hereby declare that the project report entitled Working Capital the outcome of my own work and the same has not been submitted to any University / Institute for the award of any degree. Sumit Singh Registration No:-016-1121-0250-10 Roll No: - 301-0063 B-com (Honours), 3rd year Syma Prasad College 2 ACKNOWLEDGEMENT Success is the outcome of diligence & perseverance, I, Sumit Singh, student of SYMA PRASAD COLLEGE Of B-com( Honours) of 3rd Year would, like to ascribe to my success in completing my project’ “Working Capital” and to my project supervisors My College Faculties who have extended their sincere help in accomplishing my project. I really want to thank the above mentioned to all my faculties and my mentors for their continuous support & guidance during the project, without their help my project would have been a distant dream. Sumit Singh Registration No:-016-1121-0250-10 Roll No: - 301-0063 B-com (Honours), 3rd year Syma Prasad College 3 Table of Contents 1. 2. 3. 4. 5. 6. 7. 8. 9. Executive Summary………………………………………………………………………………………5 Company Overview………………………………………………………………………………….……6 Research Methodology……………………….……….………………………………………….....….….8 Objective ………………………………………………………………………...

Words: 8238 - Pages: 33

Premium Essay

Capital Budgeting

...Management Science-II Prof. R.Madumathi MODULE 2 Capital Budgeting • Capital Budgeting is a project selection exercise performed by the business enterprise. • Capital budgeting uses the concept of present value to select the projects. • Capital budgeting uses tools such as pay back period, net present value, internal rate of return, profitability index to select projects. Capital Budgeting Tools • • • • • Payback Period Accounting Rate of Return Net Present Value Internal Rate of Return Profitability Index Payback Period Payback period is the time duration required to recoup the investment committed to a project. Business enterprises following payback period use "stipulated payback period", which acts as a standard for screening the project. Indian Institute of Technology Madras Management Science-II Prof. R.Madumathi Computation Of Payback Period When the cash inflows are uniform the formula for payback period is cash outflow divided by annual cash inflow Computation Of Payback Period • When the cash inflows are uneven, the cumulative cash inflows are to be arrived at and then the payback period has to be calculated through interpolation. • Here payback period is the time when cumulative cash inflows are equal to the outflows. i.e., Payback Reciprocal Rate • The payback period is stated in terms of years. This can be stated in terms of percentage also. This is the payback reciprocal rate. • Reciprocal of payback period...

Words: 3214 - Pages: 13

Premium Essay

Guillermo

...Furniture Store and Pro Forma Analysis Guillermo Navellez, once the owner of the largest flourishing furniture store in Sonora, Mexico faces globalization and the emergence of foreign competition. Inexpensive labor and the abundance of timber in Sonora are major factors, which contributed to the manufacturing of the store’s furniture. Guillermo faces new competition that possesses advanced technology with the ability to manufacture faster and at lower costs. With the emergence of this sophisticated technology, the company requires change to cease the decease of revenue and sales (University of Phoenix, 2012). Guillermo hires Jevaloch Consulting Firm, Incorporated to examine his current business forecast and choose strategies in optimal working capital. Additionally, Jevaloch will also provide an efficient pro forma budget and recommend an implementation plan. Guillermo Furniture Forecast Forecasting is an important tool for estimating the future market value for the business. Jevaloch consultants began the examination of Guillermo Furniture by reviewing a six month Figure 1.1 Budget Sales Forecasts. Figure 1.2 Actual Sales Forecasts. projection of sales forecast for units of chairs, the top sales item for the store, sold from January to June 2010. Figures 1.1 and 1.2 are representative of the budget unit sales and actual unit sales for Guillermo Furniture. The average monthly demands for the budget sales is 18,014/6 = 3002.3 and 17,997/6 = 2999.5 for actual sales. ...

Words: 2588 - Pages: 11

Premium Essay

Finance

...Financial decision making Contents Introduction: 1 Task: 1 1 (a) Ratio analysis on the basis of AstraZeneca Annual Report and Form 20-F Information 2012: 1 (b) Business structure and financial structure (comparison and relative advantages of the chosen organization) 5 (c) Compare and comment on the finances of business: 7 (d)Recommend potential investor for the investment decision: 8 (e)All possible Sources of finance for 500000 and best source 8 (f) Management of working capital: 10 Task 2: 11 (a)Preparations of a cash flow forecast and comment on budget and cash flow: 11 (b)Recommendation for managing cash flow: 12 Task 3: 12 (a)Assessment of projects by financial techniques: 12 (b) Recommendation from the above calculations and reason behind the choice: 13 Conclusions: 14 Reference: 15 Introduction: Finance is the paramount part of every organization. Whatever the size of the company, financing plays a vital role in the business organization. Ratio analysis is an important tool for the business decision as well as for the interpretation of the financial statements. We have selected AstraZeneca Annual Report & form 20-F information 2012. All the ratio analysis and decision in respect of the business structure as well as financial structure are based on this particular company. Investment appraisal techniques like- NPV, internal rate of return, payback period, accounting rate of return are based on the given data. This report suggests appropriate decision...

Words: 3459 - Pages: 14