Build balance sheet and income statement financial model

Assignment Help Financial Accounting
Reference no: EM131289809

A company has the following ratios:

Current ratio - .85

Inventory to Sales Conversion Period – 180 days

Sales to Cash Conversion Period – 40 days

Purchases to Payments Conversion Period - 7 days

The accountant also reports that the gross profit margin is 15% and the next profit margin is 3%.  

Now you are being provided with this additional information on the company.The company also has a bank line of credit that allows the company to borrow any shortfall it might have in cash. Interest on the loan is 10%. Assume the loan remained constant throughout the year.

The company has $1,000,000 of equity and $120,000 in retained earnings at the end of the year.

Sales in the most recent year were $2,500,000.

Ignore income tax for purposes of this problem.

1. Based on all of the above information, will this company have a good return on equity or a poor return on equity?

2. Build a balance sheet and income statement financial model to prove your answer.

Reference no: EM131289809

Questions Cloud

Adventureworks database in the left pane : After opening SQL Server, go to the AdventureWorks database in the left pane, expand the database, right click on database diagrams, click new database diagrams, and explore the ERD for AdventureWorks until you can identify the tables necessary to..
Analyzing and interpreting retirement benefit footnote : Retirement Benefits: The Company maintains the Abercrombie & Fitch Co. Savings & Retirement Plan, a qualified plan. All U.S. associates are eligible to participate in this plan if they are at least 21 years of age and have completed a year of employm..
Draw valuable information from the research : Did those who presented this exhibit or event succeed in revealing values and a level of civic engagement in the community in which it was presented? Why, or why not?
Determine adoption of digital education across arab region : What are the key factors that will determine the adoption of digital education across the Arab region? Assuming there is sufficient funding, what other issues might the rise of digital education raise?
Build balance sheet and income statement financial model : A company has the following ratios: Current ratio - .85. Inventory to Sales Conversion Period – 180 days. Sales to Cash Conversion Period – 40 days. Based on all of the above information, will this company have a good return on equity or a poor retur..
Explaqin how the given concept could affect the us economy : Identify at least four key points of a relevant economic article from either the Strayer Library or a newspaper. Explain how the concept that you identified in Question 2 could affect the U.S. economy.
Research a food scandal in your own country : Research a food scandal in your own country. What impact did it have on demand? What was the government reaction? Did the suppliers suffer?
Why do companies hedge foreign exchange risk : Why do companies hedge foreign exchange risk? What are the differences between a forward contract and a foreign currency option? What term is used for an option with a positive intrinsic value? What is the concept underlying the two-transaction persp..
Advantage of an instant manufacturers rebate : Many car dealerships advertise that they will finance your purchase at low interest rate or you can take advantage of an instant manufacturers rebate. Assume you are in this dilemma, you found the perfect car for $20,000. You have a plan to pay off t..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Federated fabrications leased tooling machine

Federated Fabrications leased a tooling machine on January 1, 2016, for a three-year period ending December 31, 2018. The lease agreement specified annual payments of $39,000 beginning with the first payment at the inception of the lease, and each De..

  All-terrain vehicle to transport participants and supplies

Tony and Suzie see the need for a rugged all-terrain vehicle to transport participants and supplies. They decide to purchase a used Suburban. The cost of the Suburban is $12,400. The vehicle is purchased in late June and will be put into use on July ..

  Required to publish annual financial statements

Public companies are required to publish annual financial statements. Suggest the major benefits of companies making financial statement information available to employees. Briefly explain generally accepted accounting principles (GAAP), and describe..

  Industries incurs unit costs

Manson Industries incurs unit costs of $8 ($5 variable and $3 fixed) in making an assembly part for its finished product. A supplier offers to make 10,000 of the assembly part at $6 per unit. If the offer is accepted,

  Prepare the profit and loss account for the period

Prepare the profit and loss account for the period. Explain what you understand by ‘period costs' and discuss your treatment of them in the calculations you have carried out.

  General ledger entry to record the purchase of materials

The general ledger entry to record the purchase of materials is:

  Prepare general journal entries to record these transactions

To launch the company, Jenna Aracel, the owner, invested $215,000 cash, office equipment with a value of $8,700, and $74,000 of drafting equipment in exchange for common stock. The company purchased land worth $55,000 for an office by paying $9,400 c..

  Determine the cost recovery

Jen acquired an apartment building on June 4, 2016, for $1.4 million. The value of land is $200,000. Jen sold the apartment building on November 29, 2022. Determine Jen’s cost recovery for 2016. Determine Jen’s cost recovery for 2022.

  Determine the unit sales to attain that target profit

Assume the company’s monthly target profit is $69,000. Determine the unit sales to attain that target profit. Assume the company's monthly target profit is $41,400. Determine the dollar sales to attain that target profit.

  Creates a proposal for international expansion

Creates a Proposal for International Expansion That Includes a Discussion of Constraint Theory Importance in the Decision Process. Incorporates CVP Analysis, Balanced Scorecard, and Complete Budgeted Financial Statements.

  Required - use the following information to complete

required - use the following information to complete phillip and claire dunphysnbsp2013nbspfederal income tax return.

  Nemani corporation is projecting a cash balance of 31785 in

nemani corporation is projecting a cash balance of 31785 in its december 31 2013 balance sheet. nemani schedule of

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