Business Analysis; Spreadsheet Application Davidson Yachts is a small company founded by two businesspeople who are friends and avid sailors. At present, they are interested in expanding the business and have asked you to review its financial statements.

Davidson Yachts sells approximately 100 to 150 sailboats each year, ranging from 14-foot dinghies to 20-foot sailboats. Their sales prices range from $2,000 to more than $10,000. The company has a limited inventory of boats consisting primarily of one or two boats from each of the four manufacturers that supply Davidson. The company also sells a variety of supplies and parts and performs different types of service. Most sales are on credit.

The company operates from a large building that has offices, storage, and sales for some of the smaller sailboats. The larger sailboats are kept in a fenced area adjacent to the main building, and an ample parking area is nearby. This year Davidson purchased a boat lift to haul boats. The lift has brought in revenues for boat repairs, hull painting, and related services, as well as the boat hauls.

Page 863

The balance sheet and income statement for Davidson Yachts for 20112016 follow. The increase in net fixed assets in the recent two years is due to improvements in the building, paving of the parking area, and the purchase of the lift.

The company obtains its debt financing from two sources: a small savings and loan for its short-term funds, and a larger commercial bank, also for short-term loans, but principally for long-term financing. The terms of the loan agreement with the bank include a restriction that its current ratio must remain higher than 1.5.

Required

Evaluate the liquidity and profitability of Davidson Yachts using selected financial ratios. Assess the companys overall profitability, liquidity, and desirability as an investment. Use a spreadsheet to improve the speed and accuracy of your analysis.

DAVIDSON YACHTS COMPANY Comparative Statement of Income and Operating Cash Flow For the Years Ended December 31 2012 2011 2013 2014 2015 Sales Returns and allowances Cost of sales Gross margin Depreciation expense Interest expense Salaries and wages Accounting and legal Administration expense Other expense $767,580 $724,878 $777,480 $929,478 $764,610 $948,857 38,379 35,645 40,334 45,998 32,887 47.380 473,908 441,298 458,015 545,778 453,669 530,597 $255,293 $247,935 $279,131 $337,702 $278,054 $370,880 S 29,075 27,458 29,450 35,207 29,128 $ 40,080 18,597 19,557 20,998 21,475 24,889 28,993 81,923 73,664 77846 95,764 92,903 101,447 9,323 1,834 3,10 1380 79,666 75,234 80,693 96,469 87,995 97.441 12,630 18,927 15,763 22,903 18,934 22,662 $231,195 $223,626 $234,073 S283,652 $266,957 S302,003 S 24,098 S 24,309 $ 45,058 S 54,050 $ 11,097 $ 68,877 9,304 8,786 Total expense Net income Cash flow from operations (adjustments to net income) Depreciation Decrease (increase) in receivables Decrease (increase) in inventory Decrease (increase) in other current assets Increase (decrease) in current liabilities S 27,458 29,450 S35,207 29,128 S 40,080 (3,887) 10,031) 10,318) 7,291 34 397) (21,775 5,008 6,092) 8,890 37,780)