Question: I need excel. You can read it if you right click on the mouse and press open the photo in new tab. (Related to Checkpoint

I need excel. You can read it if you right click on the mouse and press open the photo in new tab.
(Related to Checkpoint 17.1) (Discretionary financing needs) Harrison Electronics, Inc. operates a chain of electrical lighting and fixture distribution centers throughout northern Arizona. The firm is anticipating expansion of its sales in the coming year as a result of recent population growth trends. The firm's financial analyst has prepared pro forma balance sheets that reflect three different rates of growth in firm sales for the coming year and the corresponding non-discretionary sources of financing the firm expects to have available, as follows: a. What are the firm's discretionary financing needs under each of the three growth scenarios? b. What potential sources of financing are there for Harrison to fulfill its needs for discretionary financing? Data Table a. The discretionary financing needs for a 10% growth scenario are $ . (Round to the nearest dollar.) Harrison Electronics, Inc. Pro Forma Balance Sheet for 2014 Alternative Growth Rates Calculation 10% 20% 40% Current assets $14,310,000 $13,290,000 $19,750,000 $16,870,000 $25,280.000 Net fixed assets $21,670,000 Total $33,040,000 $35,980,000 $42,150,000 $2,220,000 $2,360,000 $2,830,000 Accounts payable Accrued expenses Notes payable 2.110.000 2,340.000 2,720,000 1,450,000 No change 1,450,000 1,450,000 Current liabilities $6,150,000 6,400,000 $12,550,000 $7,000,000 6,400,000 No change $5,780,000 6,400,000 $12,180,000 $1,030,000 2,070,000 15,450,000 Long-term debt Total liabilities Common stock (par) Paid-in capital Retained earnings Common equity $1,030.000 No change No change $13,400,000 $1,030,000 2,070,000 15,780,000 2,070,000 15,620,000 $18,550,000 $18,720,000 $18,880,000 Projected sources of financing $30,730,000 $31,270,000 $32,280,000 Discretionary financing needs Total financing needs = Total assets
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
