BBA 3301 Unit V Assignment Instructions: Enter all answers...

BBA 3301 Unit V Assignment Instructions: Enter all answers...

Author: Minnie Fisher


BBA 3301 Unit V AssignmentInstructions: Enter all answers directly in this worksheet. When you are finished, select Save As, andsave this document using your last name and student ID as the file name. Upload the data sheet toBlackboard as a .doc, .docx or .rtf file when you are finished.Question 1. (30 points total) Use this balance sheet and income statement from Carver Enterprises tocomplete parts a and b:a. (15 points) Prepare a common size balance sheet for Carver Enterprises. Complete the commonsize balance sheet: (Round to one decimal place.)Common−Size Balance SheetCash and marketable securitiesAccounts receivableInventoriesCurrent assetsNet property plant and equipmentTotal assetsAccounts payableShort−term debt$$$$20134905,9909,55016,03017,03033,0607,2206,800%%%% BBA 3301 Unit V AssignmentCurrent liabilities$Long−term liabilitiesTotal liabilities$Total owners’ equityTotal liabilities and owners’ equity $14,0207,01021,03012,03033,060%%%b. (15 points) Prepare a common-size income statement for Carver Enterprises. Complete thecommon-size income statement: (Round to one decimal place.)Common−Size Income StatementRevenuesCost of goods soldGross profitOperating expensesNet operating incomeInterest expenseEarnings before taxesTaxesNet income2013$ 30,020(19,950)$ 10,070(7,960)$ 2,110(940)$ 1,170(425)$ 745%%%%%Question 2. (10 points total) Use this data table of Campbell Industries liabilities and owners' equity tocomplete parts a and b.a. (5 points) What percentage of the firm's assets does the firm finance using debt (liabilities)?(Round to one decimal place.)b.(5points) If Campbell were to purchase a new warehouse for $1.3 million and finance it entirely withlong-term debt, what would be the firm's new debt ratio? (Round to one decimal place.)Question 3. (10 points total) (Liquidity analysis) Airspot Motors, Inc. has $2,433,200 in current assetsand $869,000 in current liabilities. The company's managers want to increase the firm's inventory, whichwill be financed using short-term debt. How much can the firm increase its inventory without its currentratio falling below 2.1 (assuming all other assets and current liabilities remain constant)? (Round to onedecimal place.) BBA 3301 Unit V AssignmentQuestion 4. (10 points total) (Efficiency analysis) Baryla Inc. manufactures high quality decorator lampsin a plant located in eastern Tennessee. Last year the firm had sales of $93 million and a gross profitmargin of 45 percent.a. (5 points) How much inventory can Baryla hold and still maintain an inventory turnover ratio of atleast 6.3 times? 

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.