Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Details seen in image. I am unsure of where i need to put the bank loan of 816,000. Seen in exhibit 8 on the left,

Details seen in image. I am unsure of where i need to put the bank loan of 816,000. Seen in exhibit 8 on the left, i must have a bank balance of 102,000 before getting the loan. Seen on the right side in the may column, that is the first year where my bank balance is over 102,000. I am mainly unsure of if i need to put the 816,000 loan in the "add cash collections' tab. I have just added this in but I don't know if this is okay to do. Should i be putting in the balance in cash collections in May as i have got over 102,000, and then pay the loan off in June under borrowings? Thanks for your help

image text in transcribed
AutoSave O OFF n A 9 9 . C ... Excel.xisx - 2 AutoSave O OFF A A 9 9 . C ... Excel.xIsx - 1 Home Insert Draw Page Layout Formulas Data Review View > Tell me Comments Share Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share Conditional Formatting 11 AA ab v Custom Insert v A Calibri (Body) Format as Table v Delete Paste Font Sensitivity Alignment Number Cells Editing Analyse Sensitivity Paste $ ~ % 9 08 58 Conditional Format Cell Cell Styles v IUV Formatting as Table Styles Format v DV Sort & Find & Analyse Data Filter Select Data N21 X fx =ROUND('/Usersaadiyaomar/Downloads/[Travel-Space%20Trailers%20Solutions%20(sem1, N21 X fx | 816000 K L M N O P G A B C D E F 32 17 Total sheet metal purchases 143,820 134,640 113,220 70,380 35,190 7,650 33 18 Cost per square yard 3.16 $ 3.16 $ 3.16 $ 8.16 $ 3.16 $ .16 34 EXHIBIT 8. 287,150 $ 62,424 35 BANK LOAN DETAILS / MINIMUM CASH BALANCE REQUIRED 19 Total cost 1,173,571 $ 1,098,662 $ 923,875 $ 574,301 $ 36 Requested loan amount $ 816,000 20 37 Loan duration (in days) 90 21 H BUDGET 38 22 Jan Feb March April May June Six M 39 Mininum cash balance required by directors S 102,000 23 Cash beginning balance S 102,000 $ (910,180) $ (2,016,040) $ (2,397,520) $ (1,262,260) $ (2,717,820) 40 24 Add: cash collections 41 25 Cash (From Bank Loan) 816,000 42 26 Month of sale 637,500 $ 1,020,000 $ 1,275,000 $ 765,000 561,000 $ 280,500 43 27 Month following sale 217,400 255,000 $ 408,000 $ 510,000 $ 306,000 $ 224,400 44 45 28 Second month following sale 880,800 $ 1,304,400 $ 1,530,000 $ 2,448,0 3,060,000 $ 1,836,000 46 29 Total cash collections 1,837,700 $ 1,669,220 $ 1,196,960 1,325,480 $ 140,220 $ (376,920) 47 30 Total cash available 48 31 Less: cash disbursements 49 32 Aluminum $ 714,000 $ 1,077,120 $ 905,760 $ 563,040 $ 342,720 $ 244,800 50 33 Other materials 153,00 269,280 226,440 140,760 85,680 91,800 51 34 Wages 536,480 1,028,160 1,126,080 685,440 140,640 244,800 52 35 Heat, light, & power 132,600 198,900 224,400 137,700 112,200 112,200 53 36 Equipment rental 397,800 397,800 397,800 346,800 $46,800 346,800 54 37 Equipment purchases 306,000 306,000 306,000 306,000 306,000 306,000 55 38 Selling & admin 408,000 408,000 408,000 408,000 408,000 408,000 56 39 Total cash disbursements $ 2,747,880 $ 3,685,260 $ 3,594,480 $ 2,587,740 $ 2,042,040 $ 1,754,400 58 40 Excess (deficiency) (910,180) $ 2,016,040) $ (2,397,520) $ (1,262,260) $ (1,901,820) $ (2,131,320) 41 Financing: 60 42 Borrowings: Original $ 816,000 43 Borrowings: Additiona 62 44 Repayments 63 64 45 Interest 65 46 To be invested (excess) 66 47 Total financing $ $ $ $ 816,000 $ 67 48 Cash balance ending 910,180) $ (2,016,040) $ 2,397,520) $ (1,262,260) $ (2,717,820) 68 49 69 50 EXHIBITS BLANK BASED ON PROJECTIONS BASED ON PRODUCTION (3060) BASED O + EXHIBITS BLANK BASED ON PROJECTIONS BASED ON PRODUCTION (3060) BASED ON PRODUCTION (3570) + 190% Ready fox Accessibility: Investigate 170% Ready fox Accessibility: Investigate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

What training is required for the position?

Answered: 1 week ago