Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!


I need help answering this question. Please find the information attached. I am willing to negotiate on the price. I need it by today Evening.

Problem 7-43 (80-100 min.) Return to Assignments Name
Section 7-43 Comprehensive Cash Budgeting (Hongren, Sundem, Schatzberg, & Burgstahler, 2012, p. 304)
Christine Morrison, treasurer of Salt Lake Light Opera (SLLO), was preparing a loan request to the South Utah National Bank in December
20X4. The loan was necessary to meet the cash needs of the SLLO for year 20X5. In a few short years, the SLLO had established itself as a
premier opera company. In addition to its regular subscription series, it started a series for new composers and offered a very popular holiday
production. The holiday production was the most financially successful of the SLLO’s activities, providing a base to support innovative
productions that were artistically important to the SLLO but did not usually succeed financially. (Hongren, Sundem, Schatzberg, &
Burgstahler, 2012, p. 303)
Exhibit 7-14
Salt Lake Light Opera
Balance Sheets as of December 31 (in thousands of dollars)
Accounts receivable
Supplies inventory
Total current assets
Plant and equipment
Total assets
Liabilities and Equities
Bank loan
Accounts payable
Accrued payroll expenses
Mortgage, current
Total current liabilities
Other payables
Mortgage payable, long-term
Net assetst
Total liabilities and equities
*Incudes $32,000 of accrued interest. 20X4 $
$ 2,688
8,973 $
$ 229
9,139 $
$ 208
10,957 $
$ 420
8,973 $
$ 720
1,553 $
$ 1,620
3,296 $ * 1
$ 3,500 $
4,086 $
9,139 $ 3,250
10,957 The Net assets account for a nonprofit organization is similar to “Stockholders’ equity” for
a corporation.
1 Exhibit 7-15
Salt Lake Light Opera
Income Statements for the Year Ended December 31 (in thousands of dollars)
Ticket sales $ 3,303 $ 4,060 $ 5,263 Contributions $ 1,041 $ 1,412 $ 1,702 Grants and other revenues $ 1,202 $ 1,361 $ 1,874 Total revenues $ 5,546 $ 6,833 $ 8,839 Production $ 4,071 $ 4,805 $ 6,307 Operations $ 271 $ 332 $ 473 Public relations and community development $ 1,082 $ 1,421 $ 1,734 Total expenses $ 5,424 $ 6,558 $ 8,514 Excess of revenues over expenses $ 122 $ 275 $ 325 Expenses* *Expenses include depreciation of $355, $370, and $470 and general and administrative
expenses of $1,549, $1,688, and $2,142 in the years 20X2, 20X3, and 20X4, respectively.
In total, the SLLO had done well financially, as shown in Exhibits 7-14 and 7-15. Its profitable operations had enabled it to build its own
building and generally acquire a large number of assets. It had at least broken even every year since its incorporation, and management
anticipates continued profitable operations. The Corporate Community for the Arts in Salt Lake and several private foundations had made
many grants to the SLLO, and such grants are expected to continue. Most recently, the largest bank in town had agreed to sponsor the
production of a new opera by a local composer. The SLLO’s director of development, Harlan Wayne, expected such corporate sponsorships to
increase in the future.
To provide facilities for the Opera’s anticipated growth, SLLO began work on an addition to its building 2 years ago. The new facilities are
intended primarily to support the experimental offerings that were becoming more numerous. The capital expansion was to be completed in
20X5; all that remained was acquisition and installation of lighting, sound equipment, and other new equipment to be purchased in 20X5.
SLLO had borrowed working capital from South Utah National Bank for the past several years. To qualify for the loans, the SLLO had to
agree to the following: Problem 7-43 (80-100 min.) Return to Assignments Name
Section 1 Completely pay off the loan for 1 month during the course of the year. 2 Maintain cash and accounts receivable balances equal to (or greater than) 120% of the loan. 3 Maintain a compensating cash balance of $200,000 at all times. In the past, the SLLO has had no problem meeting these requirements. However, in 20X4 the SLLO had been unable to reduce the loan to
zero for an entire month. Although South Utah continued to extend the needed credit, the loan manager expressed concern over the situation.
She asked for a quarterly cash budget to justify the financing needed for 20X5. Ms. Morrison began to assemble the data needed to prepare
such a budget.
SLLO received revenue from three main sources: ticket sales, contributions, and grants. Ms. Morrison formed Exhibit 7-16 to calculate the
accounts receivable balance for each of these sources for 20X5. She assumed that SLLO would continue its normal practices for collecting
pledges and grant revenues. Ticket Sales First Quarter
Second Quarter
Third Quarter
Fourth Quarter Revenues
1519 Contributions End of Quarter
3683 Revenues
442 End of
1170 Grant
End of
1342 Most expenses were constant from month to month. An exception was supplies, which were purchased twice a year in December and June. In
20X5, SLLO expects to purchase $200,000 of supplies in June and $700,000 in December on terms of net, 30 days. The supplies inventory at
the end of December was expected to be $600,000. Depreciation expense of $500,000 was planned for 20X5, and other expenses were
expected to run at a steady rate of $710,000 a month throughout the year, of which $700,000 was payroll costs. Salaries and wages were paid
on the Monday of the first week following the end of the month. The remaining $10,000 of other expenses were paid as incurred. The major portion of the new equipment to be installed in20X5 was to be delivered in September; payments totaling$400,000 would be made
in four equal monthly installments beginning in September. In addition, small equipment purchases are expected to run $20,000 per month
throughout the year. They will be paid for on delivery. In late 20X2, SLLO had borrowed $4 million (classified as a mortgage payable) from Farmers’ Life Insurance Company. The SLLO is
repaying the loan over 16years, in equal principal payments in June and December of each year. Interest at 8% annually is also paid on the
unpaid balance on each of these dates. Total interest payments for 20X5, according to Ms. Morrison’s calculations, would be $275,000. Interest on the working capital loan from South Utah National Bank was at an annual rate of 10%.Interest is accrued quarterly but paid
annually; payment for 20X4’s interest would be made on January10, 20X5, and that for 20X5’s interest would be made on January 10, 20X6.
Working capital loans are taken out on the first day of the quarter that funds are needed, and they are repaid on the last day of the quarter when
extra funds are generated. SLLO has tried to keep a minimum cash balance of $200,000at all times, even if loan requirements do not require it. 1. Compute the cash inflows and outflows for each quarter of 20X5. What are SLLO’s loan requirements each quarter?
2. Prepare a projected income statement and balance sheet for SLLO for 20X5.
3. What financing strategy would you recommend for SLLO?


Solution details:


This question was answered on: Sep 05, 2019

Solution~000200247198.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

testimonials icon
Question Description In her book...
testimonials icon
Deals-R-Us Brokers: Fred Jones, a distant relative of yours and president of Deals-R-Us Brokers (DRUB), has come to you for advice. DRUB is a small...
testimonials icon
Practical methods to improve safety in the workplace. Topics include OSHA and other regulations, hazard recogniti...
testimonials icon
Principles of Accounting 301 Week 3 HomeworkExercise #1Listed below are five procedures followed by Paul Company.GoodWeakPrinc...
testimonials icon
Order Grade A+ Academic Papers Instantly!...
testimonials icon
 Using the Internet, locate TWO companies that provide VPN services. Compare the TWO different services offered. Include their services, pricing,...
testimonials icon
dq 1WEEK 3: PRACTICUM DISCUSSION FORUM11 unread reply.3131 replies.Tell us about your practicum experiences this week....
testimonials icon
For completion of chapter 12 and final....
testimonials icon
PSYC 324 Quiz 2Part 1 of 1 – Quiz 2 – Week 2Question 1 of 202.0 PointsWhile opening the doors to a new populat...
testimonials icon
Go on internet and download an article of a survey that was done (just 1) no specific topic for the survey. (Find the summary of the survey...
Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price