Question: ooo Forecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stode them in conveniently located warehouses, shos them to its chain of

ooo Forecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stode them in conveniently located warehouses, shos them to its chain of retail stores, and a stiff to advise atomers and he them set up their new computers Upton's balance sheet as of December 11, 2021, chowners of dollars) ca $15 Accounts payable $90 Receivables 260 Notes payable 18.0 Inventories 580 Line of crede Total current awut $325 Acous AS 35.0 Total content lite S255 Mortgage lom Common stock 15.0 Retained earn 4.0 Yolas $122.5 Totalities and equity 5125 Sales for 2021 were $225 mition, and net income for the year was $6.75 milion, so the firm's protagon w oponad dividends of 2.7 milion to common stockholders, so sporo ratio was 10% state was 25 and it operated city that allows to spontaneous babes nation, the profit magn and the payout to remain constantin 2022. Do not undermins es we proud to increase ty on, uning 2027, the Nation to determine Uptor's projecte del equirements Enter your answer. For can www020,000 should be entered 10. Round Your swer to two decimal places in the Nation, determine supporting growth rate this, what is the maximum where the man deve without having to employ nonpontinous ? Round your answer to two decades che forested to statement method to forecast post sheet for December 31, 2022. Asume that will extema catalansed as a line of credit at the end of the year (Benthede til det at the end of the year, there will be notion est de to the new desume Upton's profit marginal dividend payout will be there in 2022 Hy were in 2021. What the of the line of credit reported on the 2022 forecasted balance sheet: You need to forecast the income items be the line of credit taken out on the last day of the year and you are over the projected sales prontmargin and dividend payout ratio these gures allow you to the 2022 in to read for the balance sheet without actually constructing tulime statement Enter your answers in this for me, anwer of $10.550,000 should be entered as 10.55. Round your answers to Two decimal c. Use the forecasted cal statement method to forecast Upton's balance sheet for December 31, 2022. Asume that wadonal external capitale is a line of credit at the end of the year. (Because the debt is added at the end of the year, there will be notional interest Expense due to the new dett) Asume Upton's profit margin and dividend payout ratio will be the same in 2022 as they were in 2021 What is the amount of the line of credit reported on the 2022. forecasted balance sheets? You don't need to forecast the income statements because the line of credit is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio: these gres atlow you to calculate the 2032 addition to retained caring for the balance sheet without actually constructing a full income statement. Enter your answers in milion. For example, an answer of 10,550,000 should be entered as 10. Round your wiwers to two decimal places Upton Computers Pro Forma Balance Sheet December 31, 2022 (Millions of Dollars) Cash 5 Receivables $ $ Inventones Total current sets Netfonds 5 5 To sets $ 5 Accounts payable Notes pastile Line of credit Acous Total current Horton Commons Metsand earnings Totalt $ $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
