Question
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
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