Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help I am not sure how to calculate the repayment amount Jason Allen, Vaughn & Matthew Fabricators budget director, has received budget information from

Please help I am not sure how to calculate the repayment amount

Jason Allen, Vaughn & Matthew Fabricators budget director, has received budget information from several managers and is preparing the companys cash budget.

January February March Quarter

Collections from sales

478,200 560,860 636,720 1,675,780

Payments for direct materials

80,505 253,125 280,730 614,360

Payments for direct labor

98,640 103,680 116,640 318,960

Payments for manufacturing overheads

78,490 78,980 80,240 237,710

Payments for Selling & administrative expenses

111,400 116,440 123,160 351,000

In addition to the information he received from these managers, Jason knows the following:

Vaughn & Matthew plans to have $32,400 in its cash account on January 1.
Vaughn & Matthew plans to purchase and pay cash for a piece of land in January at a cost of $85,000.
Vaughn & Matthew plans to make a cash purchase of equipment in March at a cost of $28,000.
Vaughn & Matthew's income taxes from last quarter totaling $26,400 will be paid in January.
Vaughn & Matthew is required to maintain a minimum cash balance of $50,000 in its account at First National Bank.

Vaughn & Matthew has negotiated with the First National Bank to provide a $175,000 line of credit that can be borrowed against in $1,000 increments on the first day of the month. Any repayments on the line of credit must also be made in $1,000 increments and are made on the last day of the month when cash is available. The annual interest rate on this line of credit is 6%. Any time a principal payment is made, all accrued interest to date is repaid. Prepare Vaughn & Hills cash budget for the first quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

January

February

March

Quarter

Beginning cash balance

$32,400 $50,165 $ $

Collections from sales

478,200 560,860

Total cash available to spend

510,600 611,025

Less: Disbursements

Payments for direct materials

80,505 253,125

Direct labor

98,640 103,680

Manufacturing overhead

78,490 78,980

Selling & administrative expenses

111,400 116,440

Land and Equipment purchases

85,000 0

Income Taxes

24,400 0

Total cash disbursements

478,435 552,225

Cash excess (deficiency)

32,165 58,800

)Minimum cash balance

-50,000 -50,000

Cash excess (needed)

-17,835 8,800

Financing

Borrowings

18,000

Repayments

0

Interest

0 -180

Total financingFinancing

18,000

Ending cash balance

50,165

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions

Question

What needs do all people have in common?

Answered: 1 week ago

Question

Please show your steps for the following question:

Answered: 1 week ago