Your assignment is to create a monthly personal cash budget using Excel or any other spreadsheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your assignment is to create a monthly personal cash budget using Excel or any other spreadsheet software for your upcoming academic year, July 1, 2020 - June 30, 2021. Feel free to adapt in any way meaningful to you. Be sure to include all potential sources of income: Work income Scholarships/ grants Loans/Financial Aid Parental assistance And all potential expenses: Tuition room/board Books Food Rent Utilities Transportation Cell phone Internet Entertainment Clothes Make it as realistic as you can, but as is the case with a budget in some cases you have to estimate. Remember that every month will not be the same. Some months you have other obligations (think about December and gifts) or maybe you have a family event coming up where you may need extra cash. Master Budgets Exhibit 22-16 shows the completed cash budget. Take time to carefully examine the document to ensure you understand the calculations. Pay special attention to the Total col- umn of the cash budget. As with the production budget and direct materials budget, you cannot simply add across each row to determine the total amounts because this is a sum- mary for the entire year. For example, the beginning cash balance for the year is the same as the beginning cash balance for the first quarter, and not the sum of the beginning balances for each quarter. Exhibit 22-16 Completed Cash Budget SMART TOUCH LEARNING Cash Budget For the Year Ended December 31, 2021 Second Fourth Quarter First Third Quarter Quarter Quarter Total S 15,000 $ 30,285 S 30,190 5 32,995 %24 15,000 1,129,000 Beginning cash balance Cash receipts 250,000 268,000 293,000 318,000 Cash available 265,000 298,285 323,190 350,995 1,144,000 Cash payments: Capital expenditures 40,000 40,000 40,000 40,000 160,000 Purchases of direct materials 68,825 81,525 92,625 100,125 343,100 Direct labor 30,750 42,000 45,750 49,500 168,000 Manufacturing overhead 23,640 26,640 27,640 28,640 106,560 Selling and administrative expenses 60,000 60,250 60,500 60,750 241,500 Income taxes 17,500 17,500 17,500 17,500 70,000 Interest expense 180 180 360 Total cash payments 240,715 268,095 284,195 296,515 1,089,520 Ending cash balance before financing 24,285 30,190 38,995 54,480 54,480 Minimum cash balance desired (30,000) (30,000) (30,000) (30,000) (30,000) Projected cash excess (deficiency) (5,715) 190 8,995 24,480 24,480 Financing: Borrowing 6,000 6,000 Principal repayments (6,000) (6,000) (6,000) S 32,995 Total effects of financing 6,000 Ending cash balance $ 30,285 S 30,190 $ 54,480 54,480 The budgeted financial statements are the next step in the budgeting process, and the cash budget provides several amounts needed. The interest expense calculations are carried to the budgeted income statement, and the ending cash balance is carried to the budgeted balance sheet. Smart Touch Learning repaid all amounts borrowed during the year. If those amounts had not been repaid in full, the balance would be carried to the budgeted balance sheet as the balance for Notes Payable. Your assignment is to create a monthly personal cash budget using Excel or any other spreadsheet software for your upcoming academic year, July 1, 2020 - June 30, 2021. Feel free to adapt in any way meaningful to you. Be sure to include all potential sources of income: Work income Scholarships/ grants Loans/Financial Aid Parental assistance And all potential expenses: Tuition room/board Books Food Rent Utilities Transportation Cell phone Internet Entertainment Clothes Make it as realistic as you can, but as is the case with a budget in some cases you have to estimate. Remember that every month will not be the same. Some months you have other obligations (think about December and gifts) or maybe you have a family event coming up where you may need extra cash. Master Budgets Exhibit 22-16 shows the completed cash budget. Take time to carefully examine the document to ensure you understand the calculations. Pay special attention to the Total col- umn of the cash budget. As with the production budget and direct materials budget, you cannot simply add across each row to determine the total amounts because this is a sum- mary for the entire year. For example, the beginning cash balance for the year is the same as the beginning cash balance for the first quarter, and not the sum of the beginning balances for each quarter. Exhibit 22-16 Completed Cash Budget SMART TOUCH LEARNING Cash Budget For the Year Ended December 31, 2021 Second Fourth Quarter First Third Quarter Quarter Quarter Total S 15,000 $ 30,285 S 30,190 5 32,995 %24 15,000 1,129,000 Beginning cash balance Cash receipts 250,000 268,000 293,000 318,000 Cash available 265,000 298,285 323,190 350,995 1,144,000 Cash payments: Capital expenditures 40,000 40,000 40,000 40,000 160,000 Purchases of direct materials 68,825 81,525 92,625 100,125 343,100 Direct labor 30,750 42,000 45,750 49,500 168,000 Manufacturing overhead 23,640 26,640 27,640 28,640 106,560 Selling and administrative expenses 60,000 60,250 60,500 60,750 241,500 Income taxes 17,500 17,500 17,500 17,500 70,000 Interest expense 180 180 360 Total cash payments 240,715 268,095 284,195 296,515 1,089,520 Ending cash balance before financing 24,285 30,190 38,995 54,480 54,480 Minimum cash balance desired (30,000) (30,000) (30,000) (30,000) (30,000) Projected cash excess (deficiency) (5,715) 190 8,995 24,480 24,480 Financing: Borrowing 6,000 6,000 Principal repayments (6,000) (6,000) (6,000) S 32,995 Total effects of financing 6,000 Ending cash balance $ 30,285 S 30,190 $ 54,480 54,480 The budgeted financial statements are the next step in the budgeting process, and the cash budget provides several amounts needed. The interest expense calculations are carried to the budgeted income statement, and the ending cash balance is carried to the budgeted balance sheet. Smart Touch Learning repaid all amounts borrowed during the year. If those amounts had not been repaid in full, the balance would be carried to the budgeted balance sheet as the balance for Notes Payable.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these electrical engineering questions
-
Your Assignment is to write an essay discussing how you, as a business owner, can use annuities to achieve business goals. Financial decisions require careful planning and prioritizing, especially...
-
In order to enhance the image of DASANI bottles as contributing to sustainability, the Twist Campaign, including using Chubby Checker and his classic song, encouraged active involvement in the ad...
-
Consider a one-dimensional linear time-invariant system x = ax + bu. a) What is the system state? What is the system state space? b) What is the control input? c) Given the initial condition x(0) =...
-
The hot dog cooker described in the chapter heats hot dogs by connecting them to 120 V household electricity. A typical hot dog has a mass of 60 g and a resistance of 150 N. How long will it take...
-
This case presents an employee, Laura, discussing in a very frank and open way the negative emotional climate in her workplace. Laura describes the workplace as very cold and unproductive. She very...
-
Frame the Mattco case using the factors set forth in this chapter. Specific areas that should be addressed in this exercise include: a. Type of case b. Jurisdiction c. Professional standards d....
-
Mr. Tam is the front man for the Asian American dance-rock band The Slants. Mr. Tam named his band The Slants to reclaim and take ownership of Asian stereotypes. The band draws inspiration for its...
-
The following information is available for Aikman Company. Instructions (a) Compute cost of goods manufactured. (b) Prepare an income statement through gross profit. (c) Show the presentation of the...
-
1. An object of mass of 4 kg is resting at a height of 2 m and then falls to the ground. a. Model the energy of the object-Earth system with Energy Bar Charts when at the initial height and ground...
-
The Cascades Swim Club has 300 shareholders, each holding one share of stock in the club. A share of club stock allows the shareholders family to use the clubs heated outdoor pool during the summer...
-
The following data sets present operating data for Alaska Air Group, a North American airline. The data cover the period from 2005 to 2020 and were obtained from ALK's annual reports on Form 10-K....
-
Defining a recession and providing a short summary of whether Australia is in or heading for a recession with supporting evidence including what you think the causes of a recession for Australia...
-
Per NIMS, all interagency written and verbal communications must use common terminology in reference to what types of information? A. While not trained, they can be carefully utilized according to...
-
1. Consider the context-free grammar: S+SS+ |SS*|a And the string aa+a* a. Give a leftmost derivation for the string b. Give a rightmost derivation for the string c. Give a parse tree for the string...
-
Redesigning the Procure-to-Pay System at Coca Cola Consolidated: The CPO Perspective At the Coupa INSPIRE procurement conference in San Francisco held in April, 2013, the Chief Procurement Officer of...
-
In 2023, Giant Corporation has pre-tax income of $800,000 prior to considering the following items: Business income, net of expenses 700,000 Dividend income 200,000 Charitable contribution (100,000)...
-
Question Salleh Industries has decided to expand its business and it needs RM5 million. Three sources of financing are available: Issue long-term debt that is currently selling for 103 percent of...
-
You have just begun your summer internship at Omni Instruments. The company supplies sterilized surgical instruments for physicians. To expand sales, Omni is considering paying a commission to its...
-
Explain the steps of the spreadsheet modeling process.
-
Rapid Grower, the supplier of plant food for Greens in Problem 12, has offered the following quantity discounts. If the nursery places orders of 50 bags or less, the cost per bag is $20. For orders...
-
Develop a chase aggregate plan using hires and fires to adjust the capacity for Draper. All demand must be met each period. (a) Show what would happen if this plan were implemented. (b) Calculate the...
-
Solve the nodal displacements and element forces of the plane truss problem in figure 1.23. Use the following numerical values: \(A E=10^{7} \mathrm{~N}, L=1 \mathrm{~m}, \alpha=10^{-5} /{ }^{\circ}...
-
Consider a plane truss in figure 1.31. The horizontal and vertical members have length \(l\), while inclined members have length \(\sqrt{2} l\). Assume Young's modulus \(E=100 \mathrm{GPa}\), cross...
-
Using the 2node isoparametric element in the heat conduction equations in eq. (4.20) in chapter 4 , derive the conductivity matrix. Equation 4.20: d7 kA ST(x) dx kA dTdST dx dr -dr= -JAQ,ST(x)dr.
Study smarter with the SolutionInn App