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
-
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...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
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 = - 11,500 psi, (y = - 18,250 psi, Txy = - 7200 psi Using Mohr's circle, determine (a) the principal stresses and (b) the maximum shear stresses and associated normal stresses. Show all results on...
-
A triangle with area A=1/2 bh is expanding with time such that the length of the base, b(t) = t2 + 2, and the height of the rectangle is constant at h = 4. What is the formula for the rate of change...
-
We first study 3-PBA, a commonly used insecticide found in grains, fruits, and vegetables. How much higher are 3-PBA concentrations while not eating organic versus eating organic? A bootstrap...
-
You are engaged in the audit of Plex-Fame Corporation (PFC), a rapidly expanding, diversified, publicly traded entertainment company with operations throughout Canada and the United States. PFCs...
-
Suppose the price of gasoline increases by 20% and the demand for gasoline decreases by 10%. What is the price elasticity of demand of gasoline? Answer: x
-
For the following circuit, the power delivered to the load (RL), connected across a-b terminals, under the maximum power transfer condition is: a) 2.4 W b) 4 W c) 8 W d) 12 W 20 V 2012 10 15 4...
-
Consider these two quotes concerning recent Federal Reserve policy On December 12, 2012 the Federal Reserve issued the following statement: "In particular, the Committee decided to keep the target...
-
Is the calculation of financial return an application of time value analysis? Explain your answer.
-
Two-dimensional demand and supply curves are drawn under which of the following assumptions? A. Own price is held constant. B. All variables but quantity are held constant. C. All variables but own...
-
A market structure with relatively few sellers of a homogeneous or standardized product is best described as: A. oligopoly. B. monopoly. C. perfect competition.
-
Using the information in this chapter, label each of the following statements true, false, or uncertain. Explain briefly. a. Changes in the current one-year real interest rate are likely to have a...
-
In the 1970s, the United States experienced periods of severe gasoline shortages due to OPEC policy and unrest in the Middle East. The price of gasoline increased as a result of these shortages. In...
-
The vapor pressure of the liquid NH, is measured at different temperatures. The following vapor pressure data are obtained. Temperature, K P, mmHg 217.1 223.4 234.7 588.1 Calculate the enthalpy of...
-
Each diagram in Figure 10. 24 indicates the momentum of an object before and after a single force is exerted on it. For each case determine the direction of the force. Data from Figure 10 . 24 (a)...
-
Draw the sum \(\vec{A}+\vec{B}\) and the difference \(\vec{A}-\vec{B}\) of each vector pair in Figure 10. 23 . Data from Figure 10 . 23 88 (a) (9) L 189 (c) 109 F V 100 B (P)
-
While driving to school, you place your coffee cup on the dashboard. Which type of force of friction allows the cup to stay put on the dashboard when the car speeds up? Does this force do any work on...
Study smarter with the SolutionInn App