Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

A common size income statement for creek enterprises

22/10/2021 Client: muhammad11 Deadline: 2 Day

Business Finance Homework

Details: Complete the following problems from the textbook: (All 7 problems are printed on here)

P3-3:
P3-6
P3-10
P3-16
P3-18
P3-20
P3-21

Details: Complete the following problems from the textbook: (All 7 problems are printed on here)

· P3-3:

· P3-6

· P3-10

· P3-16

· P3-18

· P3-20

· P3-21

Follow these instructions for completing and submitting your assignment:

1. Do all work in Excel. Do not submit Word files or *.pdf files.

2. Submit a single spreadsheet file for this assignment. Do not submit multiple files.

3. Place each problem on a separate spreadsheet tab.

4. Label all inputs and outputs and highlight your final answer.

5. Follow the directions in “Guidelines for Developing Spreadsheets.”

P-3: Income statement preparation On December 31, 2015, Cathy Chen, a self-employed

certified public accountant (CPA), completed her first full year in business. During

the year, she billed $360,000 for her accounting services. She had two employees, a

bookkeeper and a clerical assistant. In addition to her monthly salary of $8,000,

Ms. Chen paid annual salaries of $48,000 and $36,000 to the bookkeeper and the

clerical assistant, respectively. Employment taxes and benefit costs for Ms. Chen and

her employees totaled $34,600 for the year. Expenses for office supplies, including

postage, totaled $10,400 for the year. In addition, Ms. Chen spent $17,000 during

the year on tax-deductible travel and entertainment associated with client visits

and new business development. Lease payments for the office space rented (a taxdeductible

expense) were $2,700 per month. Depreciation expense on the office

furniture and fixtures was $15,600 for the year. During the year, Ms. Chen paid

interest of $15,000 on the $120,000 borrowed to start the business. She paid an

average tax rate of 30% during 2015.

a. Prepare an income statement for Cathy Chen, CPA, for the year ended December

31, 2015.

b. Evaluate her 2015 financial performance.

P3–6: Balance sheet preparation Use the appropriate items from the following list to prepare

in good form Mellark’s Baked Goods balance sheet at December 31, 2015.

Item Value ($000 Item Value ($000) at

Item December 31, 2015 December 31, 2015 December 31, 2015

Accounts payable

$ 220

Inventories

$375

Accounts receivable

450

Land

100

Accruals

55

Long-term debts

420

Accumulated depreciation

265

Machinery

420

Buildings

225

Marketable securities

75

Cash

215

Notes payable

475

Common stock (at par)

90

Paid in capital in excess

Cost of goods sold

2,500

of par

360

Depreciation expense

45

Preferred Stock

100

Equipment

140

Retained Earnings

210

Furniture and fixtures

170

Sales Revenue

3,600

General expense

320

Vehicles

25

P3–10: Statement of retained earnings Hayes Enterprises began 2015 with a retained earnings

balance of $928,000. During 2015, the firm earned $377,000 after taxes. From

this amount, preferred stockholders were paid $47,000 in dividends. At year-end

2015, the firm’s retained earnings totaled $1,048,000. The firm had 140,000 shares

of common stock outstanding during 2015.

a. Prepare a statement of retained earnings for the year ended December 31, 2015,

for Hayes Enterprises. (Note: Be sure to calculate and include the amount of cash

dividends paid in 2015.)

b. Calculate the firm’s 2015 earnings per share (EPS).

c. How large a per-share cash dividend did the firm pay on common stock during

2015?

P3–16: Accounts receivable management An evaluation of the books of Blair Supply, which

follows, gives the end-of-year accounts receivable balance, which is believed to consist

of amounts originating in the months indicated. The company had annual sales

of $2.4 million. The firm extends 30-day credit terms.

Month of origin Accounts receivable

July $ 3,875

August 2,000

September 34,025

October 15,100

November 52,000

December 193,000

Year-end accounts receivable $300,000

a. Use the year-end total to evaluate the firm’s collection system.

b. If 70% of the firm’s sales occur between July and December, would this information

affect the validity of your conclusion in part a? Explain.

P3–18: Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested

a $4,000,000 loan, to assess the firm’s financial leverage and financial risk. On the

basis of the debt ratios for Creek, along with the industry averages (see the top of

the next page) and Creek’s recent financial statements (following), evaluate and

recommend appropriate action on the loan request

Creek Enterprises Income Statement for the Year Ended December 31, 2015

Sales revenue $30,000,000

Less: Cost of goods sold 21,000,000

Gross profits $ 9,000,000

Less: Operating expenses

Selling expense $ 3,000,000

General and administrative expenses 1,800,000

Lease expense 200,000

Depreciation expense 1,000,000

Total operating expense $ 6,000,000

Operating profits $ 3,000,000

Less: Interest expense 1,000,000

Net profits before taxes $ 2,000,000

Less: Taxes (rate 5 40%) 800,000

Net profits after taxes $ 1,200,000

Less: Preferred stock dividends 100,000

Earnings available for common stockholders $ 1,100,000

P3–20: Common-size statement analysis A common-size income statement for Creek Enterprises’

2014 operations follows. Using the firm’s 2015 income statement presented in

Problem 3–18, develop the 2015 common-size income statement and compare it with

the 2014 statement. Which areas require further analysis and investigation?

Creek Enterprises Common-Size Income Statement

for the Year Ended December 31, 2014

Sales revenue ($35,000,000) 100.0%

Less: Cost of goods sold 65.9

Gross profits 34.1%

Less: Operating expenses

Selling expense 12.7%

General and administrative expenses 6.3

Lease expense 0.6

Depreciation expense 3.6

Total operating expense 23.2

Operating profits 10.9%

Less: Interest expense 1.5

Net profits before taxes 9.4%

Less: Taxes (rate 5 40%) 3.8

Net profits after taxes 5.6%

Less: Preferred stock dividends 0.1

Earnings available for common stockholders 5.5%

P3–21: The relationship between financial leverage and profitability Pelican Paper, Inc.,

and Timberland Forest, Inc., are rivals in the manufacture of craft papers. Some financial

statement values for each company follow. Use them in a ratio analysis that

compares the firms’ financial leverage and profitability.

Item Pelican Paper, Inc. Timberland Forest, Inc.

Total assets $10,000,000 $10,000,000

Total equity (all common) 9,000,000 5,000,000

Total debt 1,000,000 5,000,000

Annual interest 100,000 500,000

Total sales 25,000,000 25,000,000

EBIT 6,250,000 6,250,000

Earnings available for

common stockholders 3,690,000 3,450,000

a. Calculate the following debt and coverage ratios for the two companies. Discuss

their financial risk and ability to cover the costs in relation to each other.

1. Debt ratio

2. Times interest earned ratio

b. Calculate the following profitability ratios for the two companies. Discuss their

profitability relative to one another.

1. Operating profit margin

2. Net profit margin

3. Return on total assets

4. Return on common equity

c. In what way has the larger debt of Timberland Forest made it more profitable

than Pelican Paper? What are the risks that Timberland’s investors undertake

when they choose to purchase its stock instead of Pelican’s?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
Professional Coursework Help
Coursework Assignment Help
Maths Master
Assignments Hut
Calculation Guru
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$23 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$44 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$29 Chat With Writer
Maths Master

ONLINE

Maths Master

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$48 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$50 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$44 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

2 discussion question and a one page paper - Data structures in java tutorial pdf - Ethical points discussion - Philosophy - Mitosis and meiosis amoeba sisters - Sjone board - Joint application for disposal of security bond form - Jarvis v swan tours ltd 1973 qb 233 case report - Sample letter for procurement of materials - Ap bio lab 12 answers - Final Strategic Plan - How do i get a mak key - Advanced Business Statistics - Navy federal order checks - Penn foster biology research paper example - What area does one gallon of paint cover - Use the following information for meeker corp. to determine the amount of equity to report. - Saini v all saints haque centre - Hands on a hardbody character descriptions - How to stop procrastinating and write an essay - Ethics - Topic 5: Emergency Preparedness and Disaster Management - Bethany hamilton workout - Direct and inverse variation word problems worksheet with answers - Human thigh bones are stronger than concrete - Hess's law a level chemistry questions - Parts of a sewing machine worksheet - Jbhifi change of mind - Crc handbook of avian body masses - One page assignment - Who is the leech in scarlet letter - Chick fil a strategic plan - E maketing final - Epidemiology - Justice law clerk singapore - Solitaire company's fixed budget performance - We will fight we will win lyrics vincent bohanan - Spindle orientation g code - Starbucks venti social responsibility and brand strategy - Long term care week 5 - C cl ir stretch - Toms shoes stakeholders - Describe the type of pay structure (merit, pay-for-performance, et cetera) that exists in your current workplace or a previous workplace. - Create scrum board in excel - What is the greatest common factor of 36 and 40 - Week 4/ part 2 - How do repressive regimes interact with civil society - Thomas and kilmann's five approaches to conflict - Vernon claims that his contract with ulani is voidable. if their contract is avoided - First act lola ce140 - Accounting II 1st Discussion - Week 7 - Why does sifers grayson need an application lifecycle management tools - Bike data project - Midland energy resources excel - Is position distance or displacement - Containerization in Maritime Shipping , High Customer Integration and Satisfaction, Social Policy - Telco bella vista woolworths - The skillful teacher saphier pdf - Sentence starters for essays - Alfie kohn beyond discipline - Swivel packing top drive - Office 365 dlp reports - Northern territory beekeepers association - Information needs and wants of the ancient communities - 23 south wharf promenade south wharf vic 3006 - Chromatography of food dyes lab results - Is copper more reactive than iron - La dueña nos abrió la sección de no fumar - Conflict resolution steps nursing - Tst 102 sraw test plan - The giver chapter 7-8 answers - Casey nelson is a divisional manager - Commemorative speech about my mother - United airlines case study analysis - How to write a soap note for nurse practitioners - Find all six trigonometric functions - Clark healthy workplace inventory - Spark plug catalogue pdf - Maersk betting on blockchain - Fedex organisational structure - 6 step sales process - Difference between hanging wall and footwall - Stage 3 english units of work - Baltimore truss bridge analysis - Where is jollibee in australia - Workplace level 2 first aid certificate tasmania - Human biology preclinical curtin handbook - What is biological weathering for kids - Electron configuration of sulfur - VIOLENT CRIMES CJT202 ASSIGNMENT - Experiment 1 observation of mitosis in a plant cell - Schneider altistart 48 fault codes - Vit_min brain teaser answer - Growth maturation and physical activity 2nd edition - Apple cider vinegar enema for hemorrhoids - Dragons den wiz of biz - How to graph marginal cost and marginal revenue in excel - The goal a process of ongoing improvement book summary - Strategic plan part 3 balanced scorecard