Camping USA Inc has only been operating for 2 years in the outskirts of Albuquerque, New Mexico and is a new manufacturer of a top of the line camping tent. You are starting an internship as assistant to the chief financial officer of the company, and the owner and CEO, Tom Charles, has decided that this is the right time to know more about the business and financial risks his company must deal with. For this, the CFO has asked you to prepare an analysis to support him in his next meeting with Tom Charles a week from today.;To make the required calculations, you have put together the following date regarding the cost structure of the company: Output level 120,000 units, Operating assets $6,000,000, Operating asset turnover 12 times, Return on operating assets 48%, Degree of operating leverage 10 times, Interest expense $720,000, tax rate 42%. The CFO has instructed you to first determine the break even point in units of output for the company. He requires that you prepare supporting documents which demonstrate how you arrived at your conclusion and can facilitate his review of your work. Accordingly, you are required to have the information needed to prepare an analysis income statement for the company to be presented to the CFO. In a format that is acceptable for a meeting discussion with the CFO, you also need to prepare answers to the following questions.;a. What is the firm?s break even point in sales dollars?;b. If sales should increase by 40 percent, by what percentage would EBT (earnings before taxes) and net income increase?;c. Prepare another income statement, this time to verify the calculations from part b.;Please use excel to calculate. Clearly label the calculations of the required ratios using excel to solve. use formulas to calculate the ratios and format the cells to insert a comma if there is more than 3 numbers. round to the nearest whole number. in each part, summarize your analysis in a concise management statement.
Paper#31647 | Written in 18-Jul-2015Price : $27