1. Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma Income Statement and a 2018 Balance Sheet using the following 2017 and 2016 data: Fashion Trends, Inc. Balance Sheet For the Period Ended Dec. 31, 2017 2017 2016 6,148,000 5,134,000 4,176,000 3,422,000 1,972,000 1,712,000 Sales Cost of Goods Sold Gross Profit S,G&A Expenses Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Net Income 588,000 590,000 70,000 70,000 478,000 446,000 836,000 606,000 186,000 182,000 650,000 424,000 195,000 127,200 455,000 296,800 Assets Cash and Equivalents Accounts Receivable Inventory Fashion Trends, Inc. Balance Sheet As of Dec. 31, 2017 Total Current Assets Plant & Equipment Accumulated Depreciation Net Fixed Assets Total Assets Liabilities and Owners' Equity Accounts Payable Short-term Notes Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 2017 862,000 1,006,000 578,000 2,446,000 2,008,000 9,338,000 8,644,000 4,590,000 4,112,000 4,748,000 4,532,000 7,194,000 6,540,000 764,000 158,000 2016 678,000 730,000 600,000 540,000 198,000 a) What is the Discretionary Financing Needed (DFN) in 2018? Is this a surplus or deficit? b) DFN will be absorbed by long-term debt. Set up an iterative worksheet to eliminate it. 318,000 1,240,000 2,046,000 3,286,000 2,900,000 1,638,000 1,616,000 2,270,000 2,024,000 3,908,000 3,640,000 7,194,000 6,540,000 228,000 966,000 1,934,000 The firm has forecasted sales of $7,100,000 and a tax rate of 40% for 2018. Cost of goods sold and S,G&A expense in 2018 are expected to be the average of their two-year proportion of sales. On the balance sheet, accounts receivable, inventory, accounts payable, and accrued expenses are expected to be at the two-year average of the proportion of these items in relation to sales. The firm has planned an investment of $500,000 in fixed assets in 2018, with an estimated life of 10 years and no salvage value. These fixed assets will be depreciated using the straight line depreciation method. All other financial statement items are expected to remain constant in 2018. Assume the firm pays 4% interest on short-term debt and 7% on long term debt. Assume that the dividends in 2018 will be the same as those paid in 2017. 1. Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma Income Statement and a 2018 Balance Sheet using the following 2017 and 2016 data: Fashion Trends, Inc. Balance Sheet For the Period Ended Dec. 31, 2017 2017 2016 6,148,000 5,134,000 4,176,000 3,422,000 1,972,000 1,712,000 Sales Cost of Goods Sold Gross Profit S,G&A Expenses Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Net Income 588,000 590,000 70,000 70,000 478,000 446,000 836,000 606,000 186,000 182,000 650,000 424,000 195,000 127,200 455,000 296,800 Assets Cash and Equivalents Accounts Receivable Inventory Fashion Trends, Inc. Balance Sheet As of Dec. 31, 2017 Total Current Assets Plant & Equipment Accumulated Depreciation Net Fixed Assets Total Assets Liabilities and Owners' Equity Accounts Payable Short-term Notes Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 2017 862,000 1,006,000 578,000 2,446,000 2,008,000 9,338,000 8,644,000 4,590,000 4,112,000 4,748,000 4,532,000 7,194,000 6,540,000 764,000 158,000 2016 678,000 730,000 600,000 540,000 198,000 a) What is the Discretionary Financing Needed (DFN) in 2018? Is this a surplus or deficit? b) DFN will be absorbed by long-term debt. Set up an iterative worksheet to eliminate it. 318,000 1,240,000 2,046,000 3,286,000 2,900,000 1,638,000 1,616,000 2,270,000 2,024,000 3,908,000 3,640,000 7,194,000 6,540,000 228,000 966,000 1,934,000 The firm has forecasted sales of $7,100,000 and a tax rate of 40% for 2018. Cost of goods sold and S,G&A expense in 2018 are expected to be the average of their two-year proportion of sales. On the balance sheet, accounts receivable, inventory, accounts payable, and accrued expenses are expected to be at the two-year average of the proportion of these items in relation to sales. The firm has planned an investment of $500,000 in fixed assets in 2018, with an estimated life of 10 years and no salvage value. These fixed assets will be depreciated using the straight line depreciation method. All other financial statement items are expected to remain constant in 2018. Assume the firm pays 4% interest on short-term debt and 7% on long term debt. Assume that the dividends in 2018 will be the same as those paid in 2017.
Expert Answer:
Related Book For
Valuation The Art and Science of Corporate Investment Decisions
ISBN: 978-0133479522
3rd edition
Authors: Sheridan Titman, John D. Martin
Posted Date:
Students also viewed these general management questions
-
Prepare a pro forma income statement and balance sheet for Webb Enterprises Where revenues are expected to grow by 20% in 2016. Make the following assumptions in making your forecast of the firms...
-
The income statement and a partial balance sheet for Jefferson Company is presented below. Prepare the operating activities section of the statement of cash flows using the directmethod Jefferson...
-
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...
-
Consider the following differential equation describing a plug flow bioreactor: dy --Dy+py dt dz -(4-2)D-2uy dt where D = 0.4, 0.52/(0.1+),and the initial conditions are y(0) = 1 and z(0) = 4. a)...
-
A force P is applied as shown to a uniform cone which is supported by three cords, where the lines of action of the cords pass through the vertex A of the cone. Knowing that the cone weighs 2.4 lb...
-
Butanoic acid has a partition coefficient of 3.0 (favoring benzene) when distributed between water and benzene. Find the formal concentration of butanoic acid in each phase when 100 mL of 0.10 M...
-
Adopt the assumptions of the previous exercise, but assume there is no risk-free asset and there is consumption only at date 1. Show that the vector p = is an equilibrium price vector for any >...
-
Medistar is a real estate development company specializing in the development of medical facilities. Dr. Schmidt, the team physician for the San Antonio Spurs basketball team, sought to develop The...
-
DO IT! Recording Business Activities Kate Browne engaged in the following activities in establishing her salon, Hair It Is: 1. Opened a bank account in the name of Hair It Is and deposited $20,000 of...
-
A mechanism for pushing small boxes from an assembly line onto a conveyor belt, repeated from Prob. 5/89, is shown with arm OD and crank CB in their vertical positions. For the configuration shown,...
-
1. The accompanying table shows the price and monthly demand for barrels of gosum berries in Gondwanaland. Price of gosum Native Demand for berries per barrel gosum berries per month $100 0 $90 100...
-
From the perspective of organizational structure, design, and control, what have gone wrong at PNB? What factors have contributed to its current state of disarray? What should be done next to help...
-
Your goal is to advise the President on domestic economic policy. Role You are the chair of the Council of Economic Advisors (CEA) Audience Your audience is the President of the United States....
-
omework quiz 2.1 #1 stem plot The miles per gallon rating for 30 cars are shown below (lowest to highest). 19, 19, 19, 20, 21, 21, 25, 25, 25, 26, 26, 28, 29, 31, 31, 32, 32, 33, 34, 35, 36, 37, 37,...
-
Your answers are saved automatically. Question Completion Status: QUESTION 1 13 points Save Answer Library A computer memory manufacturer specifies that its memory chip stores data incorrectly an...
-
Analyze the possible reasons for and responses to Chung's request for a private office. What factors might impact Leary's decision? Identify at least two challenges and dilemmas in managing...
-
Consider the following situations for Shocker: 1. On November 28, 2021, Shocker receives a $3,900 payment from a customer for services to be rendered evenly over the next three months. Deferred...
-
A circular concrete shaft liner with Youngs modulus of 3.4 million psi, Poissons ratio of 0.25, unconfined compressive strength 3,500 psi and tensile strength 350 psi is loaded to the verge of...
-
Construct a spreadsheet model for each of the following exercises and then use the model to build a simulation model. a.Jason Enterprises faces uncertain future sales. Specifically, for the coming...
-
Refer to the HMG example HMG Corporation is considering the manufacture of a new chemical compound that is used to make high-pressure plastic containers. An investment of $ 4 million in plant and...
-
Building one Properties is a limited partner-ship formed with the express purpose of investing in commercial real estate. The firm is currently considering the acquisition of an office building that...
-
P6-2 Upstream and downstream sale of depreciable asset Jenna OYJ was a 90 percent-owned subsidiary of Mikko OYJ and was acquired in 2012. At the acquisition date, any fair value/book value...
-
E 6-9 Depreciable asset downstream sale On July 1, 2013, Fatou SA sells equipment to Baba SA, its 75 percent-owned subsidiary, for $6,000,000. The equipment has a book value of $4,500,000 at this...
-
2. On January 1, 2014, Jenna OYJ sold equipment with a book value of $1,000,000 to Mikko OYJ for $1,200,000. The equipment had a remaining useful life of 4 years. Mikko OYJ depreciated the equipment...
Rhyme And Dime A Musical Journey To Financial Success 1st Edition - ISBN: 979-8860160194 - Free Book
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App