Please tell me step by step procedure to find out maximum borrowing for lathe purchase in different months using scenario analysis
April May 149,500 175,500 June 223,600 July 184,600 August 157,300 September 120.900 October 98,800 November 105,300 25% 60% 15% 55,900 105,300 22,425 183,625 110.760 46.150 134,160 26,325 206,635 94.380 39,325 110,760 33,540 183,625 72,540 30,225 94.380 27,690 152,295 59,280 24,700 72,540 23,595 120,835 63. 180 Create a scenerio analysis to find the maximum borrowing for the lathe purchase in different months June July August Sept Oct 60% 134,160 40% 60% Sales Collections: Cash First Month Second Month Total Collections Purchases Payments: During Month Month After Total Payments Collections Disbursements: Inventory Payments Short-term Interest New Lathe Other Payments Total Disbursements Beginning Cash Balance Net Additions to Cash Unadjusted Cash Balance Add: Current Borrowing Ending Cash Balance 43,418 80.496 123,914 183,625 36,997 66,456 103,453 206,635 28,436 56,628 85,064 183,625 23,238 43.524 66,762 152.295 24,767 35,568 60,335 120,835 123.914 85,064 312 66,762 288 60,335 221 104,000 227,914 30,000 (44,289) (14,289) 39,289 25,000 103,453 131 60,000 97,500 261,084 25,000 (54,449) (29,449) 54,449 25,000 91,000 176,376 25,000 7,249 32,249 (7.249) ( 25,000 65,000 132,050 25,000 20,245 45,245 (20,245) 25,000 58,500 119,055 25,000 1,780 26,780 (1,780) 25.000 30,000 30,000 Max Borrowing - 39,289 93,738 86,489 66.244 64,464 Cumulative Borrowing Minimum Cash Balance Discount for Paying in Same Month Annual Interest Rate Monthly Interest Rate 25,000 2.00% 4.00% 0.33% Total Interest Cost 953 Actinha April May 149,500 175,500 June 223,600 July 184,600 August 157,300 September 120.900 October 98,800 November 105,300 25% 60% 15% 55,900 105,300 22,425 183,625 110.760 46.150 134,160 26,325 206,635 94.380 39,325 110,760 33,540 183,625 72,540 30,225 94.380 27,690 152,295 59,280 24,700 72,540 23,595 120,835 63. 180 Create a scenerio analysis to find the maximum borrowing for the lathe purchase in different months June July August Sept Oct 60% 134,160 40% 60% Sales Collections: Cash First Month Second Month Total Collections Purchases Payments: During Month Month After Total Payments Collections Disbursements: Inventory Payments Short-term Interest New Lathe Other Payments Total Disbursements Beginning Cash Balance Net Additions to Cash Unadjusted Cash Balance Add: Current Borrowing Ending Cash Balance 43,418 80.496 123,914 183,625 36,997 66,456 103,453 206,635 28,436 56,628 85,064 183,625 23,238 43.524 66,762 152.295 24,767 35,568 60,335 120,835 123.914 85,064 312 66,762 288 60,335 221 104,000 227,914 30,000 (44,289) (14,289) 39,289 25,000 103,453 131 60,000 97,500 261,084 25,000 (54,449) (29,449) 54,449 25,000 91,000 176,376 25,000 7,249 32,249 (7.249) ( 25,000 65,000 132,050 25,000 20,245 45,245 (20,245) 25,000 58,500 119,055 25,000 1,780 26,780 (1,780) 25.000 30,000 30,000 Max Borrowing - 39,289 93,738 86,489 66.244 64,464 Cumulative Borrowing Minimum Cash Balance Discount for Paying in Same Month Annual Interest Rate Monthly Interest Rate 25,000 2.00% 4.00% 0.33% Total Interest Cost 953 Actinha
