Description
Unit V Assignment
To complete the assignment, click here to download the worksheet, and type your answers in the fields provided. Save the document using your last name and student ID. Once complete, upload your assignment to Blackboard for grading.
Information about accessing the Grading Rubric for this assignment is provided below.
Explanation & Answer
You are welcome. Please send me the excel sheet and the task
Hello i have done the calculations in the worksheet i hope there will be no problem. Thanks a lot.
BBA 3301 Unit V Assignment
Instructions: Enter all answers directly in this worksheet. When you are finished, select Save As, and
save this document using your last name and student ID as the file name. Upload the data sheet to
Blackboard 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 to
complete 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 Sheet
Cash and marketable securities
2013
$
Accounts receivable
Inventories
Current assets
$
Net property plant and equipment
490
1.5%
5,990
18.1%
9,550
28.1%
16,030
48.5 %
17,030
51.5 %
Total assets
$
33,060
100.0 %
Accounts payable
$
7,220
21.8 %
BBA 3301 Unit V Assignment
Short−term debt
6,800
20.6 %
14,020
42.4 %
7,010
21.2 %
21,030
63.6 %
Total owners’ equity
12,030
36.4 %
Total liabilities and owners’ equity $
33,060
100.0 %
Current liabilities
$
Long−term liabilities
Total liabilities
$
b. (15 points) Prepare a common-size income statement for Carver Enterprises. Complete the
common-size income statement: (Round to one decimal place.)
Common−Size Income
Statement
Revenues
Cost of goods sold
Gross profit
Operating expenses
Net operating income
Interest expense
Earnings before taxes
Taxes
Net income
2013
$ 30,020
100.0 %
(19,950)
-66.5 %
$ 10,070
33.5 %
(7,960)
-26.5 %
$ 2,110
7.0 %
(940)
-3.1 %
$ 1,170
3.9 %
(425)
-1.4 %
$ 745
2.5 %
Question 2. (10 points total) Use this data table of Campbell Industries liabilities and owners' equity to
complete parts a and b.
a. (5 points) What percentage of the firm's assets does the firm finance using debt (liabilities)?
(
R
𝑇𝑜𝑡𝑎𝑙 𝐿𝑖𝑎𝑏𝑖𝑙𝑖𝑡�...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Unf*ck Yourself
by Gary John Bishop
The Hunger Games
by Suzanne Collins
100 Side Hustles
by Chris Guillebeau
Cant Hurt Me - Master Your Mind and Defy the Odds
by David Goggins
Communist Manifesto
by Karl Marx
The House of the Seven Gables
by Nathaniel Hawthorne
The Girl With The Dragon Tattoo
by Stieg Larsson
Don Quixote
by Miguel de Cervantes