Answered step by step
Verified Expert Solution
Link Copied!

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.image text in transcribed

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,201

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

Business Finance

Authors: Ronald R. Pitfield

1st Edition

0852581513, 978-0852581513

More Books

Students also viewed these Finance questions

Question

What is a key public for this product/service/concept?

Answered: 1 week ago