Prepare a pro forma balance sheet for upcoming fiscal year

Assignment Help Accounting Basics
Reference no: EM13846589

Prepare a pro forma balance sheet for the upcoming fiscal year. Company X's current balance sheet, submitted at the end of their fiscal year, September 30, 2015, is displayed below. Company X has a policy of maintaining a cash balance of $75,000. The company plans to acquire a new building for 90,000, and purchase new equipment for $15,000 over the next year. Net sales over the previous year were $3.6 million and the company expects sales to grow by 8% in the next year, with a gross margin of 12%. Purchases of materials are expected to be $3.5 million, the collection period is expected to be 30 days and accounts payable will be 15 days. Net Income is anticipated to be 1.5% of sales, and the tax rate is 30%. Company policy is to have a retention ratio of 20%, and depreciation is expected to be $40,000 over the coming year

Company X Balance Sheet as of Sept 30, 2015
Cash 89.4
A/R 300
Inventory 156.5
Current Assets 545.9
PP&E 306.7
Ace'd Depreciation 102.4
Net Fixed Assets 204.3
Other Assets 45.2
Total Assets 795.4

A/P 135,6
Notes Payable 90
Accrued Expenses & Taxes 19.4
Long-term Debt 260
Total Liabilities 505
Capital Stock 275
Retained Earnings 15.4
Total Equity 290.4
Total Liabilities & Shareholder Equity 795.4

Verified Expert

This paper analyses the investment terms and condition and the overall project requirements for the purpose of understanding how the project would operate. In this we have considered various aspects including the Sensitivity Analysis, the Terminal Value analysis and other terms for the purpose of investment decision making.

Reference no: EM13846589

Questions Cloud

What is your willingness to listen score : What is your willingness to listen score. What feedback did you receive from the quiz. Why do you think this measure was an accurate or inaccurate representation of your willingness to listen?
Advantages and disadvantages of each type of interval : What are the advantages and disadvantages of each type of interval
You add 2.0ml of 2 m hcl to 1l of .1m : You add 2.0mL of 2 M HCL to 1L of .1M HEPES buffer, PH 8.0 (pKa 7.6). Does the HEPES dissociate and how much does HEPES unassociate? Can you explain your answer please?
The commerce clause was part of the original constitution : The Commerce Clause was part of the original Constitution of the United States. What is the wording of this important clause, and where within the Constitution is it located? Please describe the development of the Commerce Clause over the years, and ..
Prepare a pro forma balance sheet for upcoming fiscal year : Prepare a pro forma balance sheet for the upcoming fiscal year. Company X's current balance sheet, submitted at the end of their fiscal year, September 30, 2015, is displayed below.
What are some of the important steps in implementing : What are some of the important steps in implementing inclusive assessment practices in a school. How can school leaders make sure that students with disabilities are being assessed properly
Discuss the primary sources of contemporary us law : Identify and discuss the primary sources of contemporary U.S. law. Discuss the concepts of contributory negligence and comparative negligence
Specializing in mortgage loans : 1.ABC is a publicly traded company, specializing in mortgage loans. In 2012, ABC made a number of adjustable rate mortgage loans to applicants with very low credit scores. ABC streamlined its application process such that they did not require proof o..
Influence to participate in the political process : Discuss:Should business wield its influence to participate in the political process?  Explain and defend your position.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Manufactures two types of vases

Rose Incorporated manufactures two types of vases, small and large. The following per-unit data are available.

  Clean all inc sells washing machine with a three

clean all inc. sells washing machine with a three yearwarranty. in the pastclean all has found that in the year

  Determine the ending balance in cash

Determine the ending balance in cash

  What is the free cash flow for the current year

Net income = 400 , net opening profit after taxes (NOPAT) = 600 , total asset = 2000 and total net operating capital =1800 . the information for the current year is : net income = 900 , net operating profit after taxes (NOPAT)= 800, total assets =..

  The varone company makes a single product called a hom the

the varone company makes a single product called a hom. the company has the capacity to produce 40000 homs per year.

  What is the amount of gain or loss that rsx corporation

What is the amount of gain or loss that RSX Corporation will recognize on the sale during the current year?

  Compare and contrast what motivates millennials from baby

compare and contrast what motivates millennials from baby boomers generation x and generation y. assess whether

  Direct material budget inglenook co produces wine the

direct material budget inglenook co. produces wine. the acgexpects to produce 2500000 two-liter bottles of chablis in

  Question regarding the patchwork corporation

The Patchwork Corporation manufactures sweaters for sale to athletic-wear retailers. The following information was available on Patchwork for the years ended December 31, 2013, and 2014:

  Events that occur throughout an audit examination

Following is a list of events that occur throughout an audit examination. Indicate, using the correct letter, the time period during which these events are most likely to occur. An event may occur in more than one time period.

  Shauntay james has just started a new business -building

shauntay james has just started a new business -building and installing custom garage organization systems. shauntay

  Performance audits differ from financial audits

Performance audits differ from financial audits

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