Prepare a pro forma balance sheet for december

Assignment Help Finance Basics
Reference no: EM131110861

Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2013. The firm expects 2013 sales to total $3,000,000. The following information has been gathered.

(1) A minimum cash balance of $50,000 is desired.

(2) Marketable securities are expected to remain unchanged.

(3) Accounts receivable represent 10% of sales.

(4) Inventories represent 12% of sales.

(5) A new machine costing $90,000 will be acquired during 2013. Total depreciation for the year will be $32,000.

(6) Accounts payable represent 14% of sales.

(7) Accruals, other current liabilities, long-term debt, and common stock are expected to remain unchanged.

(8) The firm's net profit margin is 4%, and it expects to pay out $70,000 in cash dividends during 2013.

(9) The December 31, 2012, balance sheet follows.


863_7.JPG

a. Use the judgmental approach to prepare a pro forma balance sheet dated December 31, 2013, for Leonard Industries.

b. How much, if any, additional financing will Leonard Industries require in 2013? Discuss.

c. Could Leonard Industries adjust its planned 2013 dividend to avoid the situation described in part b? Explainhow.

Reference no: EM131110861

Questions Cloud

Define and differentiate among the three basic patterns : Define and differentiate among the three basic patterns of cash flow:(1) A single amount, (2) An annuity, and (3) A mixed stream.
What is the difference between future value and present val : What is the difference between future value and present value? Which approach is generally preferred by financial managers? Why?
Press release indicating that sales will not be as high : The SEC is trying to get companies to notify the investment community more quickly when a “material change” will affect their forthcoming financial results. In what sense might a financial manager be seen as “more ethical” if he or she follows this d..
Discuss the financing changes suggested by the statement : Prepare a pro forma balance sheet dated December 31, 2014. Discuss the financing changes suggested by the statement prepared in parta.
Prepare a pro forma balance sheet for december : Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2013. The firm expects 2013 sales to total $3,000,000. The following information has been gathered.
Explain how the percent of sales method could result : Use the percent-of-sales method, the income statement for December 31, 2012, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. Explain how the percent-of-sales method ..
Compare and contrast the statements developed : Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2013. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2013. Compare and contrast the stat..
Discuss how knowledge of the timing and amounts involved : Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $18,000. Use the analysis prepared in part a to predict Trotter's financing needs and investment oppo..
Check statements that will be affected immediately : The following represent financial transactions that Johnsfield & Co. will be undertaking in the next planning period. For each transaction, check the statement or statements that will be affected immediately.

Reviews

Write a Review

Finance Basics Questions & Answers

  Texas roks inc is considering a new quarry machine the

texas roks inc. is considering a new quarry machine. the costs and revenues associated with the machine have been

  What is effective leadership how do you know a leader is

what is effective leadership? how do you know a leader is effective or ineffective? what qualities make a leader

  Find the expected dividend for each of the next 3 years

your broker offers to sell you some shares of bahnsen amp co. common stock that paid a dividend of 2.00 yesterday.

  Computing accumulated amount of deposit

Assume you deposited $3000 in the savings account with the annual rate of interest of 2% compounded continuously.

  Perform exploratory data analysis on the relevant variables

Perform exploratory data analysis on the relevant variables

  What price should the company charge

If demand falls to 73,700 units and the company wants to continue to earn a 0.31 return, what price should the company charge.

  What are advantages and disadvantages to a taxpaying entity

What are the advantages and disadvantages to a taxpaying entity in issuing debt as opposed to equity? Explain the difference between subordinate debentures and debentures.

  How much can notes payable increase without the current

The company plans to raise funds in the short-term debt market and invest the entire amount in additional inventory. How much can notes payable increase without the current ratio falling below 1.50?

  An investment offers to pay you 10000 a year for five

an investment offers to pay you 10000 a year for five years. if it costs 33520 what will be your rate of return on the

  Property taxes in dekalb county are roughly 266 of the

property taxes in dekalb county are roughly 2.66 of the purchase price every year. if you just bought a 100000 home

  Decentralized approach and its subsidiaries

Both Adams and Wolfe are large public corporations with subsidiaries throughout the world. Adams uses a centralized approach and  makes most of the decisions for its subsidiaries. Wolfe uses a decentralized approach and its subsidiaries make most ..

  Calculate new constant growth rate

Philadelphia Corporation's stock recently paid a dividend of $2.00 per share, and stock is in equilibrium. The firm has a constant growth rate of 5% and a beta equal to 1.5.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd