Question: please help answer asap! Numbers File Edit Insert Table Organize Format Arrange View A * 67% [42 Mon 5:06 PM Q 90% Share Window Help

please help answer asap! Numbers File Edit Insertplease help answer asap! Numbers File Edit Insertplease help answer asap!

Numbers File Edit Insert Table Organize Format Arrange View A * 67% [42 Mon 5:06 PM Q 90% Share Window Help Untitled - Edited ul T Table Chart Text Shape 05 06 Co Collaborate View Zoom Add Category Insert Media Comment Format Organize + Case Intro Q1 Q3 1 04 Dropdowns 02 ........... D ........... A ** F G H K 1 L 11 * * *** '' 6 1. Beginning cash balance invested by owners $ 5b3a9 mmP QS %88%n%8% Quarter 1 Ouarter 2 Quarter 3 Quarter 4 4 2. Sale by quarter (as Sabots procedit 20'>> 29% % 215 10 11 3. Type of collections from customers: 12 Canale Ars 13 Cell Sol 14 15 Cash sales are collected in the quarter of the sale, al di salus are collected in the quarter after the sale. 16 17 4. Merchandise purchases 18 Merchandise purchases cost of goods sold are al panthe quarterfluang purchase. Iduarier purchase are taught in Olarsor 1 but paid for in qua ter 21 19 20 S. Operating expenses 21 All other operating cxpcrses al coperces cxccptccstor Mlhe expenses 6. Required investment in equipment and in cok in the first clarter 23 $ 138.000 24 25 7. Quarterly income tax payments parlingh 8000 26 27 8. Minimum er balance $ 21.000 26 29 9. Dorrowing and Repayments: Any bonowing wil alle dice on the list cay of the quarter and any open tre paid the end of the curtar. All 30 Bonningen met male in increment of $1,00. Interest on borrowing can be ignored. 31 Required: Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarters in which borrowing will be needed and the quarters) in which repayments can be 32 Made as requested by the company's bank. Mountain Sports Cash Budget For the year ended December 31 QUA 2 1 al 215 S110.250 4 223 $115,500 YRAI Summary 100 $525.000 $ $147.003 S-52,250 34 35 36 Pront of Shes 37 Esimesed Saks 36 39 CASH BALANCE Begrine 40 Collections from customer 41 Cash Sales Note from Instructor Total amount isken from question 4 Remember lo relor lo question as this cash budget is a continuation of the Canmore expansion Introduced in Question 4. This wil be important for the cash disbursements as well 5 56,000 6 1 Formatted Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Untitled-Edited A * 67% [42 Mon 5:06 PM Q 90% T ul Chart Co Collaborate View Zoom Insert Table Text Shape Media Comment Format Organize Add Category 02 + Q3 04 Q5 06 Dropdowns Case Intro Q1 mare ar acronlechar the connau's hank D E F G H 1 K 11 Mountain Sports Cash Budget For the year ended December 31 33 Quarter 2 Note from Instructor 34 35 38 PADA SAAS 37 Estimated Galos 38 Year 4 Summary 22 100%. $116,500 $525.000 29% 5147,003 S162,250 21. S110.250 $ Total sales amount akcentrom question 4 Remember to refer to question 4 this cash Ludge is a continuation of the Carme expansion introduced in Question 4. This wil be imaortant for the cash disbursements A WAII CASH BALANCE Uogrning $ GG,UDD 40 Colecionaran customers 41 42 Cash Sales Crevil Sales 43 44 CASH AVAILABLE LARS GAN Payments Mardandis purchas 45 16 Sales Commiss Advertising 48 Property TSS 19 50 Saans & Wages 51 Equipment Purchase 52 Income tax Installment 53 Total Diabels 54 Casa wese Dency 55 Finansina (Nie 11 58 Born Repen of Principe los repalvel 58 Nel Finewing 59 Cash Balance, Ercing 80 61 Nole 1: Frerery Cukulwuns 62 Cash xoss ( Deney! 53 Minimum cash 84 Amount to borrow frepayl AF Borrowing (Repsymanta) Rounded to incremento si.000 Formatted

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!