5. After completing the pro forma income statement in problem 6-4, Mr. Tine now realizes he...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5. After completing the pro forma income statement in problem 6-4, Mr. Tine now realizes he should also complete a pro forma balance sheet. Net sales in 2015 were $90,000 and his forecasted sales for 2016 are $110,000. All of Sugar Cane Alley's current assets will remain the same percentage of sales as they were in 2015. Mr. Tine does not plan to buy or sell any equipment, so his gross property and equipment amount will remain the same as 2015. In the liabilities and equity section, only accounts payable will remain the same percentage of sales as in 2015. Except for retained earnings, the other accounts are expected to remain the same value as 2015. The following balances were taken from Sugar Cane Alley's end-of-2015 balance sheet: Cash $10,000 Accounts Receivable 2,220 Inventory 8,000led a Property and Equipment (gross) Accumulated Depreciation Property and Equipment (net) Accounts Payable Long-Term Notes Payable Retained Earnings 25,000 4,000 21,000 1,380 8,000 5,000 Common Stock 26,840 a. Calculate the forecasted end-of-2016 values for each of the current asset accounts. b. Depreciation expense for 2016 is estimated to be $2,000. Calculate the estimated total assets for the end of 2016. c. Forecast the accounts payable for the end of 2016. d. What will total liabilities be at the end of 2016? e. Assuming the forecasted net income for 2016 is $19,351 and cash dividends paid equal $10,000, what total will be forecasted for the end-of-2016 total liabilities and equity? f. Based on these calculations of the pro forma balance sheet, are additional funds needed? g. Net income for 2015 was S14,840. What was Sugar Cane Alley's net profit margin for 2015? The forecasted net income for 2016 is $19,351. What is Sugar Cane Alley's forecasted 2016 net profit margin? 5. After completing the pro forma income statement in problem 6-4, Mr. Tine now realizes he should also complete a pro forma balance sheet. Net sales in 2015 were $90,000 and his forecasted sales for 2016 are $110,000. All of Sugar Cane Alley's current assets will remain the same percentage of sales as they were in 2015. Mr. Tine does not plan to buy or sell any equipment, so his gross property and equipment amount will remain the same as 2015. In the liabilities and equity section, only accounts payable will remain the same percentage of sales as in 2015. Except for retained earnings, the other accounts are expected to remain the same value as 2015. The following balances were taken from Sugar Cane Alley's end-of-2015 balance sheet: Cash $10,000 Accounts Receivable 2,220 Inventory 8,000led a Property and Equipment (gross) Accumulated Depreciation Property and Equipment (net) Accounts Payable Long-Term Notes Payable Retained Earnings 25,000 4,000 21,000 1,380 8,000 5,000 Common Stock 26,840 a. Calculate the forecasted end-of-2016 values for each of the current asset accounts. b. Depreciation expense for 2016 is estimated to be $2,000. Calculate the estimated total assets for the end of 2016. c. Forecast the accounts payable for the end of 2016. d. What will total liabilities be at the end of 2016? e. Assuming the forecasted net income for 2016 is $19,351 and cash dividends paid equal $10,000, what total will be forecasted for the end-of-2016 total liabilities and equity? f. Based on these calculations of the pro forma balance sheet, are additional funds needed? g. Net income for 2015 was S14,840. What was Sugar Cane Alley's net profit margin for 2015? The forecasted net income for 2016 is $19,351. What is Sugar Cane Alley's forecasted 2016 net profit margin?
Expert Answer:
Answer rating: 100% (QA)
a Forecasted Current Assets value at the end of 2019 Particulars 2018 2019 Net sales 90000 110000 Cu... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-0078110894
6th Edition
Authors: Edmonds, Tsay, olds
Posted Date:
Students also viewed these general management questions
-
In program trading, computers decide when to buy or sell stocks on behalf of large, institutional investors. The computers then carry out those transactions with electronic speed. Critics claim that...
-
Pro forma income statement At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales ................... $3,000 Operating cost excluding...
-
Your assistant has prepared the following pro forma income statement for 2010. He used your forecast sales figure as the starting point. The administrative expenses are fixed except for salaries,...
-
In Problems 25 54, solve each system. Use any method you wish. 2xxy + y = 8 xy = 4
-
Be sure to determine correctly whether the confidence intervals are calculated with the normal distribution or the t distribution. In a study of the use of hypnosis to relieve pain, sensory ratings...
-
A) Search the Web for information and video clips of a Hammer and a Feather Falling on the Moon. B) Review the information and video clips. Identify your sources. C) Describe how the Hammer and the...
-
Thirty-three percent of online consumers in Russia prefer to shop online using smartphones. You randomly select 12 consumers. Find the probability that the number of online consumers who purchase...
-
The stockholders equity accounts of Holt Inc., at January 1, 2014, are as follows. Preferred Stock, $100 par, 7% .............. $600,000 Common Stock , $10 par ...............900,000 Paid-in Capital...
-
Describe the value of activity-based customer costing. Explain how ABC can help a firm identify its true low-cost suppliers. Explain driver analysis and its role in process-value analysis. Explain...
-
The strength of an item is known to be normally distributed with an unknown mean and unknown variance \({ }^{2}\). A random sample of ten items is taken and their strength measured. The strengths...
-
An electronic store sells 3,000 HD TV sets every quarter of the year. Each TV set costs the store $ 270.00. The carrying cost is set at 2% of the purchase price per unit per year. Each time an order...
-
After the global financial crisis, the central banks that fall within the framework of the Bank of International Settlement (BIS) set up the Basel III agreement in 2010. This new agreement includes...
-
Suppose you purchase a 30-year, zero-coupon bond with a yield to maturity of 4%. You hold the bond for five years before selling it. a. If the bonds yield to maturity is 4% when you sell it, what is...
-
Several multilateral or regional development banks have been created since World War II. The last born is the Asian Infrastructure Investment Bank (AIIB) created effectively in January 2016. It...
-
Suppose you purchase a 10-year bond with 11% annual coupons. You hold the bond for four years, and sell it immediately after receiving the fourth coupon. If the bonds yield to maturity was 9.94% when...
-
Assume the current Treasury yield curve shows that the spot rates for six months, one year, and 1 years are 1%, 1.1%, and 1.3%, all quoted as semiannually compounded APRs. What is the price of a...
-
time and trying to tune to each other. They attempt to play the same note and hear Two instruments, a trumpet and a saxophone, are playing at the same beats with a frequency of 4 Hz. a) If the...
-
2. In the circuit given in Figure 2, i,(t) = 5.67cos(5t)A and v (t) = 70.71 cos(5t 60) V a) Find the equivalent load impedance. State whether the load is inductive or capacitive. b) Calculate the...
-
All costs are variable because if a business ceases operations, its costs fall to zero. Do you agree with the statement? Explain.
-
Treatment of over- or underapplied overhead Kay Company and Way Company base their predetermined overhead rates on machine hours. The following information pertains to the companies most recent...
-
The budget director of Ginger's Florist has prepared the following sales budget. The company had $300,000 in accounts receivable on July 1. Ginger's Florist normally collects 100 percent of accounts...
-
Active-Ingredients is a company supplying baking ingredients in major hypermarkets that are facing intense competition from many local and foreign brands. Active-Ingredients is thinking of using a...
-
Nan-Clean is a newly developed cleaning liquid for milk bottles that uses special enzymes to remove dirt effectively. Nan-Clean has been positioned as a product that is made of natural ingredients...
-
Why do sample surveys have predetermined margins of error?
Study smarter with the SolutionInn App