Cartwrght Lumber case study

write up paper with the case summary, and the company's financial situation. And answer all of the question below.l. Why does this profitable company need cash? 2. How much cash does Cartwright need? Assume 2004 annual sales of $3.6 million (given in the case), with 20% annual growth for four years thereafter. You may also assume that Cartwright takes all possible trade discounts the last three quarters of 2004 and beyond. Assume that most operating items increase in line with their historical relation to sales. Prepare an Excel spreadsheet including—at minimum—the fiscal year-end 2004 pro forma income statement and balance sheet to show the company's cash needs. The template on Canvas provides some guidance. Optionally, you might include anticipated 2005 pro-forma financial statements as well. 3. Would you, as Mr. Dodge, agree to lend Cartwright the needed money? 4. Suppose you are advising Mr. Cartwright. What changes would you recommend he make to improve his business and its financial condition? You may consider both changes to operations as well as strategies for Mr. Cartwright to finance his operations. In making your recommendations, assume that the bank will not loan Mr. Cartwright more than 60% of his accounts receivable balance. You might confirm the results of your changes using the Excel model you developed. 5. Prepare an Excel spreadsheet with 5-year pro forma income statement and balance sheet to show the company's cash needs. 6. What are the alternatives open to Mr. Cartwright if Mr. Dodge refuses his request for an increased credit line? 7. How attractive is it to take the trade discounts?