Question: pton Computers makes bulk purchases of small computers, stocks them in convenently located warehouses, ships them to its chub of retal stores, and has a

pton Computers makes bulk purchases of small computers, stocks them in convenently located warehouses, ships them to its chub of retal stores, and has a staff to advise customers and help them set up heir new comoutes. Uptor's balance sheet as of December 31, 2021, is shown here (millons of dollars): 40\%. Its tax rate was 25%, and it operated at full capocity. Assume that at assets/ales ratios, (spontaneous labiaties)/sales ratios, the profit maryin, and the payout ratio remain constant in 2002. Do net round intermediate caloulations: a. If sales are projected to increase by 590 multion, or 24%, during 2022 , use the AFN equation to determine Upton's propected external capital requirements. Enter yeur answer in milions. for exampie. an answer of $10,550,000 should be entered as 10.55. Mound vour answer to twe drombi saces. 5. milion Round your answer to two decimal places. C. Use the forecasted financial statement method to forecast Uptens balance sheet for December 31, 20m. Assume that all add tonal externat casital is rased as a tine of credit at the end of the yeer: (Because the debt is added at the end of the vear, there will be no additional interest expense due to the new debt) Assume Upton's pront margin and dividend payout rabio wil be the same in 2022 decimal places: Upton Computers Pro Forma Batance Sheet c. Use the forecasted financial statement, method to forecast Upton's balance sheet for December 31, 2022. Assume that all addelonal external capital is raised as a line of eredt at the end of the year: (Bocause the debt is added at the end of the yeac, there wir be no addinonal interest expesse due to the new debt.) Assume Upton's profic margin and dividend payout ratio wil be the same in 2022 as they were in 2021. What is the amoumt of the line of credn reported an the 2022 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credic is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2022 additoon to retained earnings for th balance sheet without actually constructing of fal income statement.) Enter your answers in milions. Fer example, an answer of $10,550,000 should be entered as 10.55 . Round your answers to two decimal places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
