Calculate net profit margin and quick ratio

Assignment Help Financial Accounting
Reference no: EM131735110

Assignment

Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement.

Income Statement Data for 20XX
Units produced and sold = 420
Sales ($80 per unit selling price) = $33600
Cost of goods sold ($30 per unit, all variable costs) = $12600

Labor = $0 (Mr. and Mr. Lee were the only ones working and did not pay themselves)

Advertising fees =$2000
Bank fees = $150
Phone/internet = $1200
Shipping ($3 per unit) = $1260
Utilities = $900
Office supplies = $800
Interest expense on note payable = $350
Depreciation expense (straight line) = $800
Income tax rate = 26 %
Other Financial Data for 20XX:

Proceeds from sale of equipment = $3000. The equipment originally cost $1000 and had accumulated depreciation of $200.

Purchase of equipment = $1600 (The machine is purchased on the last day of 20XX so no depreciation expense is recorded.)

Repayment of note payable = $5000

Consider any data relevant from the income statement.

Balance Sheet Data for Beginning of 20XX:

Cash and cash equivalents = $10000
Accounts receivable = $0 (Cash is received at time of sale)
Raw materials inventory = $10500

Equipment = $5000 (This includes the $1000 cost of the equipment sold in 20XX).
Accumulated depreciation = $1,000 (This includes the accumulated depreciation of 200 for the equipment sold in 20XX.
Accounts payable = $0 (Cash is paid at the time of purchase.)
Note payable = $5000 (This is the note payable which is repaid in 20XX)
Common stock = $15000
Retained earnings = $4500

Financial Ratios: Calculate the following financial ratios and explain the meaning of the results.

Net Profit Margin
Quick Ratio
Debt-to-Equity Ratio.

Reference no: EM131735110

Questions Cloud

The understand that it wasnt altogether jealousy she felt : quite understand that it wasn't altogether jealousy she felt, it was rage. And not because she couldn't shop like that or dress like that
Identify the ethical choices offered by the two speakers : Identify the ethical choices offered by the two speakers - Discuss both sides of the ethical choices offered by the speakers - personal evaluation
Effect of such short lines and stanzas : Hint: you might choose to discuss the impact/effect of such short lines and stanzas.
Theme of systematic native american degradation : Describe Alexie's choice of language in crafting these images and why his word choice is vital to the poem's larger theme of systematic Native American
Calculate net profit margin and quick ratio : Calculate the following financial ratios and explain the meaning of the results. Net Profit Margin, Quick Ratio and Debt-to-Equity Ratio.
Review of the empirical literature : Financial accounting in the banking industry: A review of the empirical literature. Journal of Accounting and Economics
Discuss how to complete the assessment for the project : What additional data and /or human resources do you still need to complete the assesmenet for the project? Explain any difficulties you may be having
Respond to the ideas in the listening : How to build speaking fluency and encourage students to respond to the ideas in the listening?
Define what is the most dangerous job at the company : What is the most dangerous job at the company. Do you feel that employees are adequately informed of the risk

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd