Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX

February 26, 2024

Practice1

INPUT DATA
Forecasted annual sales growth	10%
COGS/SALES	55%
SG&A/SALES	20%
DEPRECIATION/Gross PPE	8%
INTEREST RATE	10%
TAX RATE	35%
CASH/SALES	Plug
ACCOUNT RECEIVABLE/SALES	35%
INVENTORY/SALES	85%
ACCOUNTS PAYABLE/SALES	14%
OTHER CURRENT LIAB/SALES	25%
GROSS PPE	70% of sales if Sales <=45000
	27000+0.7(Sales-40000) if 45000< Sales <= 50000
	38500+0.3(Sales-50000) if Sales > 50000
No change in dividend
No change in long-term debt and stock
SHORT-TERM BORROWING	No change
	2001	2002	2003	2004	2005	2006
INCOME STATEMENT
Sales	39,792	43,771	48,148	52,963	58,259	64,085
Cost of goods sold	(22,335)	(24,074)	(26,482)	(29,130)	(32,043)	(35,247)
Selling, general, & admin. expenses	(7,970)	(8,754)	(9,630)	(10,593)	(11,652)	(12,817)
Depreciation	(2,667)	(2,292)	(2,534)	(2,884)	(3,215)	(3,348)
Operating income	6,820	8,651	9,503	10,357	11,350	12,673
Interest expense	(3,200)	(3,580)	(3,580)	(3,580)	(3,580)	(3,580)
Earnings before taxes	3,620	5,070	5,923	6,777	7,770	9,093
Income taxes	(1,267)	(1,775)	(2,073)	(2,372)	(2,719)	(3,183)
Net Earnings	2,353	3,296	3,850	4,405	5,050	5,910
Dividends	1,500	1,500	1,500	1,500	1,500	1,500
Retentions of Earnings	853	1,796	2,350	2,905	3,550	4,410
BALANCE SHEET
Assets
Cash	1,540	(817)	(1,543)	(6,340)	(5,453)	(4,161)
Accounts Receivable	13,316	15,320	16,852	18,537	20,391	22,430
Inventories	34,717	37,206	40,926	45,019	49,521	54,473
Total Current Assets	49,573	51,708	56,235	57,216	64,458	72,741
Gross Property Plant & Equipt.	26,667	30,640	32,704	39,389	40,978	42,726
Accumulated Depreciation	(10,205)	(12,497)	(15,031)	(17,915)	(21,130)	(24,478)
Net Property Plant & Equipt.	16,462	18,142	17,673	21,474	19,848	18,248
Total Assets	66,035	69,850	73,908	78,690	84,306	90,989
Liabilities and Stockholders’ Equity
Short Term Borrowings	25,802	25,802	25,802	25,802	25,802	25,802
Accounts Payable	5,328	6,128	6,741	7,415	8,156	8,972
Other Current Liabilities	9,723	10,943	12,037	13,241	14,565	16,021
Total Current Liabilities	40,853	42,873	44,580	46,458	48,523	50,795
Long Term Debt	10,000	10,000	10,000	10,000	10,000	10,000
Total Liabilities	50,853	52,873	54,580	56,458	58,523	60,795
Stock	10,000	10,000	10,000	10,000	10,000	10,000
Retained earnings	5,182	6,978	9,328	12,233	15,783	20,194
Stockholders’ Equity	15,182	16,978	19,328	22,233	25,783	30,194
Total Liabs. & Stkhldrs’ Eq.	66,035	69,850	73,908	78,690	84,306	90,989

Practice2

INPUT DATA
Forecasted annual sales growth	10%		You find that the Cash account balance drops below zero in some years in the first question.
COGS/SALES	55%		In this question, build the the pro forma assuming that if the cash balance should be at least 2000. If needed, borrow short-term debt to make up the shortfall.
SG&A/SALES	20%
DEPRECIATION/Gross PPE	8%
INTEREST RATE	10%
TAX RATE	35%
CASH/SALES	Plug
ACCOUNT RECEIVABLE/SALES	35%
INVENTORY/SALES	85%
ACCOUNTS PAYABLE/SALES	14%
OTHER CURRENT LIAB/SALES	25%
GROSS PPE	70% of sales if Sales <=45000
	27000+0.7(Sales-40000) if 45000< Sales <= 50000
	38500+0.3(Sales-50000) if Sales > 50000
No change in dividend
No change in long-term debt and stock
SHORT-TERM BORROWING	Plug
	2001	2002	2003	2004	2005	2006
INCOME STATEMENT
Sales	39,792	43,771	48,148	52,963	58,259	64,085
Cost of goods sold	(22,335)	(24,074)	(26,482)	(29,130)	(32,043)	(35,247)
Selling, general, & admin. expenses	(7,970)	(8,754)	(9,630)	(10,593)	(11,652)	(12,817)
Depreciation	(2,667)	(2,292)	(2,534)	(2,884)	(3,215)	(3,348)
Operating income	6,820	8,651	9,503	10,357	11,350	12,673
Interest expense	(3,200)	(3,726)	(3,919)	(4,227)	(4,488)	(4,488)
Earnings before taxes	3,620	4,925	5,585	6,130	6,863	8,186
Income taxes	(1,267)	(1,724)	(1,955)	(2,146)	(2,402)	(2,865)
Net Earnings	2,353	3,201	3,630	3,985	4,461	5,321
Dividends	1,500	1,500	1,500	1,500	1,500	1,500
Retentions of Earnings	853	1,701	2,130	2,485	2,961	3,821
BALANCE SHEET
Assets
Cash	1,540	2,000	2,000	2,000	2,296	2,998
Accounts Receivable	13,316	15,320	16,852	18,537	20,391	22,430
Inventories	34,717	37,206	40,926	45,019	49,521	54,473
Total Current Assets	49,573	54,525	59,778	65,556	72,208	79,901
Gross Property Plant & Equipt.	26,667	30,640	32,704	39,389	40,978	42,726
Accumulated Depreciation	(10,205)	(12,497)	(15,031)	(17,915)	(21,130)	(24,478)
Net Property Plant & Equipt.	16,462	18,142	17,673	21,474	19,848	18,248
Total Assets	66,035	72,668	77,451	87,030	92,056	98,149
Liabilities and Stockholders’ Equity
Short Term Borrowings	25,802	28,714	29,660	34,877	34,877	34,877
Accounts Payable	5,328	6,128	6,741	7,415	8,156	8,972
Other Current Liabilities	9,723	10,943	12,037	13,241	14,565	16,021
Total Current Liabilities	40,853	45,785	48,438	55,532	57,598	59,870
Long Term Debt	10,000	10,000	10,000	10,000	10,000	10,000
Total Liabilities	50,853	55,785	58,438	65,532	67,598	69,870
Stock	10,000	10,000	10,000	10,000	10,000	10,000
Retained earnings	5,182	6,883	9,013	11,498	14,458	18,279
Stockholders’ Equity	15,182	16,883	19,013	21,498	24,458	28,279
Total Liabs. & Stkhldrs’ Eq.	66,035	72,668	77,451	87,030	92,056	98,149

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

VIDHI PATEL

VIDHI PATEL 04.10.2024 MACHINE LEARNING : MID-TERM PROJECT 2 MULTICLASS CLASSIFICATION DATASET DESCRIPTION The wine quality dataset is intriguing due to its diverse variables, including chemical properties like acidity and pH, which affect wine quality. It offers insights into the intricate relationship between these factors and perceived quality, essential for

Discussion Watch the three videos from this week’s learning materials. Analyze the videos and compare the information presented. How can this

Discussion Watch the three videos from this week’s learning materials. Analyze the videos and compare the information presented. How can this information be utilized to communicate efficiently and effectively in the workplace? Essential Activities: Watching the video, “What makes us feel good about our work” will assist you in writing

Cv7-X,li~t ~:,,11ed-leJnS: —· ·— ··–·—····-··–·-··–··-·-··—– ——— ····– .. ——- ———-··-·——···· ,. Joints: n A joint is the point of contact between two bone

Cv7-X,li~t ~:,,11ed-leJnS: —· ·— ··–·—····-··–·-··–··-·-··—– ——— ····– .. ——- ———-··-·——···· ,. Joints: n A joint is the point of contact between two bones, between bone and cartilage, or between bone and teeth. Joints con tribute to homeostasis by holding bones together in ways · that allow for movement and flexibility.

· A separately link listed below this posting contains al list case studies. Choose a case study from the list and read the information

· A separately link listed below this posting contains al list case studies. Choose a case study from the list and read the information provided. Then read 5 crucial elements in conducting a crisis audit reading in this link: After summarizing the company’s situation, using the 5 elements provided, explain

75 y.o. patient diagnosed with heart failure is seen in cardiac office for worsening of shortness of breath. He has difficulty completing sentences

75 y.o. patient diagnosed with heart failure is seen in cardiac office for worsening of shortness of breath. He has difficulty completing sentences and has productive cough. He has increased difficulty in self-care. On assessment noted bilateral crackles, +3 pedal edema, jugular vein distention. He states he takes his medications

Overview For this assignment, due in Module Two, you will complete a SMART goals chart. By now, you should be able to see how the DMAIC phases are

Overview For this assignment, due in Module Two, you will complete a SMART goals chart. By now, you should be able to see how the DMAIC phases are interconnected. This SMART goals task provides an analysis tool to help you define the conflict in the selected case study for your

First, research your chosen agency’s (The Reedy Creek Fire Department) reach on their social media platforms and then choose one of the options below to

First, research your chosen agency’s (The Reedy Creek Fire Department) reach on their social media platforms and then choose one of the options below to complete: Option 1: Based on your previous examination of your community demographics, do you feel they successfully leverage the digital tools they have chosen? Support your assessment

Goal: The goal of this assignment is to choose a topic and create a research plan Description: In the Week 1 and

Goal: The goal of this assignment is to choose a topic and create a research plan Description: In the Week 1 and Week 2 Lessons, we have read about two steps of the BIG6 model: task definition and information seeking strategies (CO1 & 2). As you consider the Week 7

PSYC 620 Case Study Paper Assignment Instructions Overview Through this paper, you will demonstrate your conceptual

PSYC 620 Case Study Paper Assignment Instructions Overview Through this paper, you will demonstrate your conceptual comprehension and clinical intervention skills by identifying and describing diagnostic criteria based on the disorders studied in this course. You will create a hypothetical case of a patient who is presenting with 2 psychological

Task 1.5: Conclusions and Recommendations Conclusions and Recommendations – 1300 words *Reference Task: 1.1 – 1.2 – 1.3 –

Task 1.5: Conclusions and Recommendations Conclusions and Recommendations – 1300 words *Reference Task: 1.1 – 1.2 – 1.3 – 1.4* · Contains the fully developed, well-conceptualised conclusions from the research and usually a bullet point list of the recommendations drawn from the conclusions. · Draws conclusions from previously analysed discussion

see attachment Scenario 2 Anna had a long history of severe mental illness dating back more than 20 years.

see attachment Scenario 2 Anna had a long history of severe mental illness dating back more than 20 years. During her first depressive episode, she had killed her baby while suffering psychotic symptoms. She also made two serious suicide attempts. Anna has been divorced twice and now lives alone in

2 references each response Week 9 transforming replies Respond to the fourolleagues by expanding upon their responses or sharing additional or

2 references each response Week 9 transforming replies Respond to the fourolleagues by expanding upon their responses or sharing additional or alternative perspectives. Include 2 references each MOM Emily: Balancing patient care with the requirement for stringent data protection poses significant challenges for healthcare practitioners. On one hand, healthcare professionals

THIS IS URGENT NEEDED IN NO MORE THAN 4 HRS The Course Project should focus on identifying a business problem or opportunity and proposing a

THIS IS URGENT NEEDED IN NO MORE THAN 4 HRS The Course Project should focus on identifying a business problem or opportunity and proposing a technological solution. You will need to identify a real-life business that you are familiar with or a fictitious business. The business must have a problem

Week 5 – Assignment: Conduct Profit Analysis Profit analysis is an analytical technique used primarily to analyze the effects of volume

Week 5 – Assignment: Conduct Profit Analysis Profit analysis is an analytical technique used primarily to analyze the effects of volume changes on profit. Consider the data in the table below for three independent health services organizations and fill in the missing data indicated by the question marks. Table 2

Add the information below and fill out the missing information for the slides. Applying Lean Six Sigma to the process of submitting monthly reports to the

Add the information below and fill out the missing information for the slides. Applying Lean Six Sigma to the process of submitting monthly reports to the property book office in the Army involves

Our Services

Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX

Practice1

Practice2

Share This Post

Related Questions

Use Our 6 Free Tools