Question: Based on the Excel sheet you created, answer the following questions. How well is the company doing? How do you think the company could obtain
Based on the Excel sheet you created, answer the following questions.
- How well is the company doing?
- How do you think the company could obtain a positive result (Describe ideas other than increasing sales (increasing income) or lowering labor costs (decreasing expenses))?
D23 fx A B E F 1 2 D International Moving Company Financing Needs 3 Month 4 January $ 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 Septembe 13 October 14 Novembe 15 Decembe Starting Balance Incomes Expenses 750,000.00 $ 1,209,081.00 $ 1,262,911.00 $ 696,170.00 1,163,811.00 1,381,881.00 478,100.00 1,300,660.00 1,250,143.00 528,617.00 1,229,207.00 1,209,498.00 548,326.00 1,248,369.00 1,355,232.00 441,463.00 1,196,118.00 1,260,888.00 376,693.00 1,162,970.00 1,242,599.00 297,064.00 1,195,824.00 1,368,955.00 123,933.00 1,305,669.00 1,235,604.00 193,998.00 1,224,741.00 1,383,254.00 35,485.00 1,159,644.00 1,411,768.00 (216,639.00) 1,210,000.00 1,540,000.00 Net (53,830.00) $ (218,070.00) 50,517.00 19,709.00 (106,863.00) (64,770.00) (79,629.00) (173,131.00) 70,065.00 (158,513.00) (252,124.00) (330,000.00 Ending Balance 696,170.00 478,100.00 528,617.00 548,326.00 441,463.00 376,693.00 297,064.00 123,933.00 193,998.00 35,485.00 (216,639.00) (546,639.00) (108,053.25) $ 70,065.00 $ (330,000.00) $ 246,380.92 696,170.00 (546,639.00) 16 Average $ 354,434.17 $ 1,217,174.50 $ 1,325,227.75 $ 17 Highest $ 750,000.00 $ 1,305,669.00 $ 1,540,000.00 $ 18 Lowest $ (216,639.00) $ 1,159,644.00 $ 1,209,498.00 $ 19 20 21 22 23 24 25 26 27 Financing Needs Formulas + > Ready + 100%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
