Borrowing Bank loan in January - Note that this is separate from any monthly borrowing. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Borrowing Bank loan in January - Note that this is separate from any monthly borrowing. It cannot be paid back early and is in effect as of 1/1. Minimum desired cash balance at the end of month $20,000 $5,000 As cash over $5,000 is available at the end of the month, you will make repayments of outstanding loans in multiples of $1,000. If additional borrowing is necessary to maintain the $5,000 end-of-month balance, you have a line of credit with the bank, and will borrow additional funds in multiples of $1,000 at the beginning of any given month. Interest (12% annual rate) is paid monthly on total outstanding borrowings at the end of the current month. All borrowings are made on the first of the month, and all repayments are made on the last day of the month. 40 41 42 43 44 45 Beginning cash balance 146 Plus: Cash collections 147 Total cash available 148 Less: cash payments: 149 Direct material purchases 150 Direct labor 151 Manufacturing overhead costs 152 Operating expenses Grammy's Blueberry Muffins CombinedBudget January- Quarter January February March Quarter 45000 $51,504 $23,114.84 $66,283 $12,678.99 $45,000.00 $172,532 $290,319 $96,504 $89,398 $185,211 $335,319 $8,713.3 $18,283.0 $30,116.5 $57,112.8 $12,044 $13,398 $27,049 $52,490 $3,126.5 $3,230.6 $4,280.7 $6,237.7 $4,505.5 $4,407.5 $5,842.5 $14,755.5 153 Tax payment 0 0 0 154 Equipment purchases $65,000 $15,000 $5,000.00 $85,000 155 Total cash payments $93,389.1 $54,318.9. $72,288.3 156 Ending cash balance before financing $3,114.84 $35,078.99 $112,922.62 $215,596.4 $119,722.62 157 Financing: 158 Plus: New borrowings 20000 0 0 20000 159 Less: Debt repayments 160 Less: Interest payments 161 Total financing 162 Ending cash balance 163 0 20000 0 2400 20000 22400 0 20000 $23,114.84 $12,679 164 165 $11.964 15 Borrowing Bank loan in January - Note that this is separate from any monthly borrowing. It cannot be paid back early and is in effect as of 1/1. Minimum desired cash balance at the end of month $20,000 $5,000 As cash over $5,000 is available at the end of the month, you will make repayments of outstanding loans in multiples of $1,000. If additional borrowing is necessary to maintain the $5,000 end-of-month balance, you have a line of credit with the bank, and will borrow additional funds in multiples of $1,000 at the beginning of any given month. Interest (12% annual rate) is paid monthly on total outstanding borrowings at the end of the current month. All borrowings are made on the first of the month, and all repayments are made on the last day of the month. 40 41 42 43 44 45 Beginning cash balance 146 Plus: Cash collections 147 Total cash available 148 Less: cash payments: 149 Direct material purchases 150 Direct labor 151 Manufacturing overhead costs 152 Operating expenses Grammy's Blueberry Muffins CombinedBudget January- Quarter January February March Quarter 45000 $51,504 $23,114.84 $66,283 $12,678.99 $45,000.00 $172,532 $290,319 $96,504 $89,398 $185,211 $335,319 $8,713.3 $18,283.0 $30,116.5 $57,112.8 $12,044 $13,398 $27,049 $52,490 $3,126.5 $3,230.6 $4,280.7 $6,237.7 $4,505.5 $4,407.5 $5,842.5 $14,755.5 153 Tax payment 0 0 0 154 Equipment purchases $65,000 $15,000 $5,000.00 $85,000 155 Total cash payments $93,389.1 $54,318.9. $72,288.3 156 Ending cash balance before financing $3,114.84 $35,078.99 $112,922.62 $215,596.4 $119,722.62 157 Financing: 158 Plus: New borrowings 20000 0 0 20000 159 Less: Debt repayments 160 Less: Interest payments 161 Total financing 162 Ending cash balance 163 0 20000 0 2400 20000 22400 0 20000 $23,114.84 $12,679 164 165 $11.964 15
Expert Answer:
Answer rating: 100% (QA)
Based on the given information it seems that the company has a specific borrowing and repayment structure with the bank Heres a summary of the key points 1 Bank loan in January The company has taken a ... View the full answer
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1111826246
6th edition
Authors: Timothy R. Mayes, Todd M. Shank
Posted Date:
Students also viewed these finance questions
-
How do you do part d? a)GHI Company's current share price is $17.65 and it is expected to pay a $0.7 dividend per share next year. After that, the firm's dividends are expected to grow at a rate of...
-
You were recently hired to improve the financial condition of Idaho Springs Hardware, a small chain of three hardware stores in Colorado. On your first day the owner, Chuck Vitaska, told you that the...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
In using the bolt cutter shown, a worker applies two 300-N forces to the handles. Determine the magnitude of the forces exerted by the cutter on the bolt. 300 N 12 mm 24 mm E 24 mm 460 mm 96 mm 300 N...
-
(x = - 3.3 MPa, (y = 8.9 MPa, Txy = - 14.1 MPa Using Mohr's circle, determine (a) the principal stresses and (b) the maximum shear stresses and associated normal stresses. Show all results on...
-
The post-implementation audit is vitally important in improving the practice of project management and the process of project management, yet it is always so difficult to get senior management and...
-
summarize the components of organizational culture;
-
In a payroll system with real-time processing of human resource management data, control issues become very important. List some items in this system that could be very sensitive or controversial....
-
\f\f
-
This is two researches please provide a lot of details in each step when answering the questions. Provide at least 6 references for each research. First research Step 1= What is HIPAA Step 2= How...
-
5. (10 pts) Consider the following fragment of C code for (int i=0; i < 100; i-i+1) x[i] =y [i+1] -3; Assume that x and y are arrays of words and the base address of x and y are in $80 and $s1,...
-
The financial information below presents selected information from the financial statements of Pelican Company. Sales revenue during the current year was $13,300,300 and cost of goods sold was...
-
Develop and defend the appropriate plans and documentation needed to initiate a project including project charter, scope, team organization, work authorization system, and change control system.
-
Landing guitars ink made 7500 and sales in 2840 and purchases in September and $10,000 and shoes and 30 1132 and purchases in October the majority of shield 80% of meeting cash and remaining 20% I am...
-
The following graph is a translation of the graph of one of the basic functions defined 2 3 by y=x, y=x, y = x, or y = |x. Find the equation that defines the function. Then, determine the largest...
-
Crystal Industries is considering an expansion project with cash flows of -$287,500, $107.500, $196,100, $104,500, and -$92,700 for Years 0 through 4. Should the firm proceed with the expansion based...
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Inventory Errors} Lhasa Corp. reported net income of \(\$ 150,000\) for 2018 and \(\$ 165,000\) for 2019. Early in 2019, McLelland discovers that the December 31,2018 , ending inventory was...
-
Inventory Analysis} Singleton Ltd. reported the following information for the current year. \section*{Required:} Compute Singleton's (a) gross profit ratio, (b) inventory turnover ratio, and (c)...
-
The stockholders equity section of the balance sheet of Pittman Corporation as of December 31, 20x7, was as follows: Pittman Corporation had the following transactions in 20x8: Feb. 28 The board of...
Study smarter with the SolutionInn App