Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: Describe in your own words some of the short-term borrowing options that the company may adopt. Here is my companies cash budget, cash inflows,
Question: Describe in your own words some of the short-term borrowing options that the company may adopt. Here is my companies cash budget, cash inflows, cash outflows, and the expected change in cash each month.
Sales 125000 126250 127512.5 128787.6 130075.5 131376.3 Nov Dec Jan Feb Mar Apr 132690 134016.9 135357.1 136710.66 138077.8 139458.5 140853.1 142261.7 May Jun Jul Aug Sep Oct Nov Dec Cash Col 123753.8 124991.3 126241.2 127503.6 128778.6 130066.4 131367.1 132680.77 134007.6 135347.7 136701.1 138068.1 123753.8 124991.3 126241.2 127503.6 128778.6 130066.4 131367.1 132680.77| 134007.6 135347.7 136701.1 138068.1 76507.5 77272.58 78045.3 78825.75 79614.01 80410.15 81214.25 82026.395 82846.66 83675.13 84511.88 85357 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $50,000 Cash Inflow Less cash Payment Dep Labor Wages Taxes Fixed Asset Purchase Rent Net cash Outflow Expected Change Opening Balance Ending cash Min. Balance Short fall/Excess $110,000 $8,000 $8,000 $8,000 $8,000 106507.5 107272.6 116045.3 158825.8 109614 118410.2 221214.3 112026.4 120846.7 113675.1 114511.9 123357 17246.25 17718.71 10195.9 -31322.1 19164.64 11656.28 -89847.2 20654.375 13160.92 21672.53 22189.25 14711.15 $10,000 $27,246 $44,965 $55,161 $23,839 $43,003 $54,660 ($35,188) ($14,533) ($1,372) $20,300 $42,490 $27,246 $44,965 $55,161 $23,839 543,003 $54,660 ($35,188) ($14,533) ($1,372) $20,300 $42,490 $57,201 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $12,246 $29,965 $40,161 $8,839 $28,003 $39,660 ($50,188) $29,533) ($16,372) $5,300 $27,490 $42,201 Sales 125000 126250 127512.5 128787.6 130075.5 131376.3 Nov Dec Jan Feb Mar Apr 132690 134016.9 135357.1 136710.66 138077.8 139458.5 140853.1 142261.7 May Jun Jul Aug Sep Oct Nov Dec Cash Col 123753.8 124991.3 126241.2 127503.6 128778.6 130066.4 131367.1 132680.77 134007.6 135347.7 136701.1 138068.1 123753.8 124991.3 126241.2 127503.6 128778.6 130066.4 131367.1 132680.77| 134007.6 135347.7 136701.1 138068.1 76507.5 77272.58 78045.3 78825.75 79614.01 80410.15 81214.25 82026.395 82846.66 83675.13 84511.88 85357 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $50,000 Cash Inflow Less cash Payment Dep Labor Wages Taxes Fixed Asset Purchase Rent Net cash Outflow Expected Change Opening Balance Ending cash Min. Balance Short fall/Excess $110,000 $8,000 $8,000 $8,000 $8,000 106507.5 107272.6 116045.3 158825.8 109614 118410.2 221214.3 112026.4 120846.7 113675.1 114511.9 123357 17246.25 17718.71 10195.9 -31322.1 19164.64 11656.28 -89847.2 20654.375 13160.92 21672.53 22189.25 14711.15 $10,000 $27,246 $44,965 $55,161 $23,839 $43,003 $54,660 ($35,188) ($14,533) ($1,372) $20,300 $42,490 $27,246 $44,965 $55,161 $23,839 543,003 $54,660 ($35,188) ($14,533) ($1,372) $20,300 $42,490 $57,201 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $12,246 $29,965 $40,161 $8,839 $28,003 $39,660 ($50,188) $29,533) ($16,372) $5,300 $27,490 $42,201Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started