Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you show me how to do this with referencing the cells, the other guy just showed me the answers. thanks in excel please WARE
can you show me how to do this with referencing the cells, the other guy just showed me the answers. thanks in excel please
WARE 17-3. (Using the percent-of-sales method of forecasting) Tulley Appliances, Inc., projects next year's sales to be $20 million. Current sales are at $15 million, based on current as- sets of $7 million and fixed assets of $8 million. The firm's net profit margin is 5 percent after taxes. Tulley forecasts that current assets will rise in direct proportion to the in- crease in sales but that fixed assets will increase by only $150,000. Currently. Tulley has $1.5 million in accounts payable (which vary directly with sales), $7 million in long-term debt (due in 10 years), and common equity (including $4 million in re- tained earnings) totaling $6.5 million. Tulley plans to pay $500,000 in common stock dividends next year. a. What are Tulley's total financing needs (that is, total assets) for the coming year? b. Given the firm's projections and dividend payment plans, what are its discretion- ary financing needs? P17-3 Modified (part A and only, also change next year's sales to be $21 million instead of $20 million) Pesert 19. on pape &D and remember the lance sheet must alonce) INCOME STATEMENT current year of sales next year % of sales sales net income dividends BALANCE SHEET 14 of current year next year % of sales 16 current newed as TOTAL ASSETS 20 11 23 23 10 scounts payable long-term de TOTAL LIABILMES COMO poder ned mig COMMON EQUITY TOTAL LIABILITIES & DE 16 Part .DISCRETIONARY FINANCING NEEDED TOTAL FINANCING NEEDED TOTAL ASSETS Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started