SmarTech manufactures and launches space stations. Use the following information to complete the cash budget in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SmarTech manufactures and launches space stations. Use the following information to complete the cash budget in the table for the year ending December 31, 2023. ● SmarTech's CEO insists that SmarTech maintain a'minimum monthly cash balance of $15 million ● ● In the event of a cash deficiency, you are instructed to borrow exactly as much as is needed to return SmarTech to the minimum cash balance required. Short-term loans carry an interest rate of 12% per year, calculated from the beginning of the quarter in which the loan is infitated and through the end of the quarter in which the loan is repaid. In the second quarter SmarTech makes a major investment in machinery amounting to $85 million. On January 1, 2021 SmarTech raised $100 million through the issue of a five-year 12% bond. Interest on this long-term debt is payable quarterly. SmarTech Particulars Cash Budget For the Year Ended December 31, 2023 (Amount in $000) Q-1 Q-2 Cash Balance, Beginning Add: Collection from Customers Total Cash Available Cash Disbursements: Direct Materials Payroll Other Costs Interest Costs (bond) Machinery Purchase Income Taxes Total Disbursements Cash Excess (Deficiency) Financing: Borrowing (at beginning) Repayment (at end) Interest (at 12% per annum) Total Effects of Financing Cash Balance, Ending 15,000 385,000 175,000 ? 50,000 ? 0 15,000 368,000 ? oooo9 32,000 ? ? 125,000 110,000 45,000 ? ? 14,000 ? (50,000) ? 0 0 ? ? Q-3 ? 95,000 40,000 ? 0 M ? 12,000 260,000 ? 0 0 0 -0 JAX Q-4 ? 365,000 155,000 118,000 49,000 ? 0 ? 345,000 ? 0 ? ? (54,500) 15.500 Year Total ? 1,360,000 ? 448,000 ? ? 85,000 61,000 1,355,000 5,000 ? (50,000) (4,500) (4,500) SmarTech manufactures and launches space stations. Use the following information to complete the cash budget in the table for the year ending December 31, 2023. ● SmarTech's CEO insists that SmarTech maintain a'minimum monthly cash balance of $15 million ● ● In the event of a cash deficiency, you are instructed to borrow exactly as much as is needed to return SmarTech to the minimum cash balance required. Short-term loans carry an interest rate of 12% per year, calculated from the beginning of the quarter in which the loan is infitated and through the end of the quarter in which the loan is repaid. In the second quarter SmarTech makes a major investment in machinery amounting to $85 million. On January 1, 2021 SmarTech raised $100 million through the issue of a five-year 12% bond. Interest on this long-term debt is payable quarterly. SmarTech Particulars Cash Budget For the Year Ended December 31, 2023 (Amount in $000) Q-1 Q-2 Cash Balance, Beginning Add: Collection from Customers Total Cash Available Cash Disbursements: Direct Materials Payroll Other Costs Interest Costs (bond) Machinery Purchase Income Taxes Total Disbursements Cash Excess (Deficiency) Financing: Borrowing (at beginning) Repayment (at end) Interest (at 12% per annum) Total Effects of Financing Cash Balance, Ending 15,000 385,000 175,000 ? 50,000 ? 0 15,000 368,000 ? oooo9 32,000 ? ? 125,000 110,000 45,000 ? ? 14,000 ? (50,000) ? 0 0 ? ? Q-3 ? 95,000 40,000 ? 0 M ? 12,000 260,000 ? 0 0 0 -0 JAX Q-4 ? 365,000 155,000 118,000 49,000 ? 0 ? 345,000 ? 0 ? ? (54,500) 15.500 Year Total ? 1,360,000 ? 448,000 ? ? 85,000 61,000 1,355,000 5,000 ? (50,000) (4,500) (4,500)
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
Use the following information to complete this exercise: sales, 550 units for $ 12,500; beginning inventory, 300 units; purchases, 400 units; ending inventory, 150 units; and operating expenses, $...
-
Use the following information to complete Keith and Jennifer Hamilton's 2015 federal income tax return. If information is missing, use reasonable assumptions to fill in the gaps. Form 1040,...
-
Use the following information to complete the balance sheet below. Current ratio = 2.5 times Profit margin = 10 percent Sales = $1,200m ROE = 20 percent Long-term debt to Long-term debt and equity =...
-
Uniform rod AB of length l and mass m lies in a vertical plane and is acted upon by a couple M. The ends of the rod are connected to small rollers which rest against frictionless surfaces. (a)...
-
Repeat Problem 70, assuming that a potential difference V = 85.0 V, rather than the charge, is held constant.
-
How is goodwill tested for impairment?
-
Consider the problem of forced oscillations. a. Derive the general solution in Equation (2.77). b. Plot the solutions in Equation (2.77) for the following cases: Let \(c_{1}=0.5, c_{2}=0, F_{0}=1.0...
-
Lager Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the master budget for the first 2 quarters of 2014. All that remains in this...
-
if someone can help me answer the following two questions. First two pictures are one problem. 3rd and 4th pic is the second problem. Thanl you. quartiles A growth chart is a plot of the percentiles...
-
Using the STUDENT table structure shown in Table P6.4, do the following: a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive...
-
Provide an example of a research experiment that you may be interested in conducting. In your response, be sure to use examples of a hypothesis, independent variable, and dependent variable
-
What is the price of a 30-year, 7% coupon rate, $1,000 face value bond that pays interest semi-annually, if the yield to maturity on similar bonds is 7.5%?
-
Which type of cost do you think is the most important to a company:direct or indirect cost? Of your chosen cost (direct or indirect), answer the following: Define the cost. Give a real-life example....
-
We are given a normally distributed random variable X with = 100 and = 15. 1. Find k such as P(X
-
How will you use the MPL (Maximum possible loss) to negotiate insurance cover?
-
2. A division in a large conglomerate has a contribution margin ratio of 20% and fixed costs of $1 million. What is the sales volume (in dollars) required to earn target net income $600,000. Assume a...
-
Given that the chosen student did not rank athletic ability as most important, find the probability that the student was a fifth grader
-
The Heese Restaurant Group manufactures the bags of frozen French fries used at its franchised restaurants. Last week, Heeses purchased and used 101,000 pounds of potatoes at a price of $ 0.70 per...
-
Compute the following ratios for The Home Depot s year ended February 2, 2014: fixed asset turnover, days to sell, and debt- to- assets. To calculate the ratios, use the financial statements of The...
-
According to the revenue recognition principle, revenues should be recognized when they are earned, which happens when the company performs acts promised to the customer. For most businesses, this...
-
As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been terminated a severance package of $ 100,000 cash; another $ 100,000 to be paid in one year; and an...
-
L Stokes drew up the following trial balance as at 30 September 19X8. You are to draft the trading and profit and loss account for the year to 30 September 19X8 and a balance sheet as at that date....
-
You are to draw up a consolidated balance sheet from the following details as at 31 December 19X9. During the year P had sold goods which had cost \( 150\) to S for \( 240\). None of these goods had...
-
Draw up a consolidated balance sheet from the following details as at 31 December 19 X8. At the balance sheet date S2 owed S1 \( 500\) and P owed S2 \( 900\). During the year P had sold goods costing...
Analyzing Statistics Through Critical Thinking And Values 1st Edition - ISBN: 0991634616 - Free Book
Study smarter with the SolutionInn App