ID 24011- Final Exam Guide - Comprehensive Notes for the exam ( 63 pages long!)
Document Summary
Get access
Related Documents
Related Questions
Governmental Budgeting and Accounting
This mini-case covers a number of the major concepts that wehave covered in class this semester. Specifically, the examrequires you to perform a break-even analysis with a weightedaverage contribution margin, prepare a quarterly operating budget,and consider a capital investment using the net present valuetechnique. The answers are cumulative. You cannot skip anysection and do the next.
You may make whatever assumptions you think are necessary toanswer any question. If needed, be sure to state every assumptionexplicitly. Turn in your answers in this Word document along withthe supporting calculations in Excel spreadsheets.
All of the information that you need to answer a given questionis provided in the text that immediately precedes the question andthe answers to the questions that precede it. Read the entireproblem set before you begin. Make sure you understand thequestions before answering them!
Santa Fe Museum of Southwestern Art
The Santa Fe Museum of Southwestern Art (SFMSA) presentsrotating exhibits of the works of artists and artisans from theSouthwestern United States. Historically, the museum has derivedits support from three sources: grants, annual memberships, andvisitor revenues. For the 2017 fiscal year, SFMSA knows that itwill receive $495,000 in grants from various sources. It alsoexpects 1,375 people to be supporting members of the museum. Onaverage, supporting members give SFMSA $105.75 per year. You canthink of the support from grants and memberships as Fixed Revenues.The museum expects the following mix of visitors during 2017, eachpaying the amount shown in the right column of the schedule.
Type of Visitor | Percent of Total | Price |
Regular | 60% | $6.00 |
Group | 18% | $3.00 |
Senior Citizen | 12% | $2.00 |
Student | 10% | $1.00 |
SFMSA has $965,000 of fixed expenses each year. In addition, themuseum spends an average of $0.62 per visitor for handouts thatdescribe the exhibits on display. SFMSA estimates that it hasvariable electric costs of $0.10 per visitor. Plus, the museumoffers each visitor the option of receiving an audio recordingwhich describes the featured exhibit of the month. Visitors areallowed to keep the recording as a memento of their visit.Historically, these recordings have cost the museum $1.30 per copyto produce and replicate. On average, 25% of the people visitingthe museum have taken advantage of the free audio recordingoffer.
Problem 1. The Directorof the museum has asked you to tell her the minimum number of totalvisitors that must come to the museum each year in order for SFMSAto break even. Using the information given above, what is SFMSAâsbreak-even visitor volume? (40 points)
Because of Santa Feâs location in themountains of New Mexico, the museum tends to have a seasonalpattern to its visitor flow with proportionally more peoplevisiting SFMSA in the summer than in the winter. In addition,revenue from grants and memberships tend to flow into the museumunevenly throughout the year. The seasonal flow of visitor, grantsand membership revenues is distributed throughout the year asfollows:
P11.1021 Summer Session - Replacement Assignment Number5
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |
Visitors | 20% | 25% | 40% | 15% |
Membership Revenue | 40% | 20% | 20% | 20% |
Grant revenue | 25% | 50% | 10% | 15% |
Weighted Average Price per ticket = (Weight of Regularvisitor in total tickets sold x Price of ticket) + (Weight of Groupvisitors in total tickets sold x Price of ticket) + (Weight ofSenior Citizen visitor in total tickets sold x Price of ticket) +(Weight of Student visitor in total tickets sold x Price ofticket)
=> (0.6 x $6) + (0.18 x $3) + (0.12 x $2) + (0.10 x$1) = $4.48 per ticket
Variable cost per visitor = Cost of handouts + variableelectric costs + (Cost of audio recording x 25%)
=> $0.62 + $0.10 + ($1.30 x 25%) =$1.045
Contribution per ticket = Selling Price â Variable cost=> $4.48 - $1.045 = $3.435
Total Fixed Cost = $965,000
Fixed Revenues = Grant + Membership Revenue => $495,000 +($105.75 x 1,375) = $640,406.25
Remaining Fixed cost = $965,000 - $640,406.25 =$324,593.75
Break-even point = Fixed cost / Contribution perticket
=> $324,593.75 / $3.435 = 94,495.99 or94,496
So, total 94,496 tickets with stated percentage ofvisitor type are required to break-even.
Fixed expenses are distributed evenly throughout the year i.e.25% per quarter. The museumâs marketing director forecasts that82,000 people will visit the museum during fiscal year 2017.
SFMSAâs Director of Marketing has convinced the ExecutiveDirector that a museum shop can be operated profitably in a smallspace just off the main entrance. She agrees and the shop isscheduled to open on April 1, 2017, the first day of the secondquarter. The Marketing Director estimates that 5% of the people whovisit the museum will make purchases from the shop. Based on hisexperience, he expects the average purchase to be $50. SFMSAâsBusiness Manager estimates that the cost-of-goods-sold will be 75%of the museum-shopâs sales revenue. The shop will be staffed byvolunteers at no cost to SFMSA.
Problem 2. Using theinformation above, prepare a properly formatted operating budgetfor SFMSA for each of the four quarters in fiscal year 2017 andsummarize the budget for the full year. (45 points)
SFMSA has just been approached by the Curator of SpecialExhibits at the Smithsonian Museum. The Smithsonian has offered tolend SFMSA a rare collection of nineteenth century Navajo crafts.The collection would remain at the museum for a five-year periodafter which it would be returned to the Navajo nation. To house theexhibit, SFMSA will have to upgrade its environmental and securitysystems at a one-time cost of $300,000. This is the only cashoutflow associated with the decision.
Since this may be the last time that this collection will beexhibited in its entirety, the Executive Director is enthusiasticabout the impact that it will have on visitor volume and thereputation of the museum. The Marketing Director forecasts that 900incremental visitors are likely to be drawn to the museum eachmonth that the exhibit is at SFMSA.
The director wants you to tell her if the exhibit is financiallyself-sufficient or if she will need to get a grant to support it.You know that SFMSAâs cost of capital is 8%. You also know themarginal contribution generated by each incremental visitor to themuseum from your work on the break-even analysis. Do not count onany gift shop purchases from the incremental visitors.
Problem 3. What do youtell her? Can SFMSA afford to show the exhibit based solely on themarginal contribution from incremental visitors? If the exhibit isnot financially self-sufficient, how large a grant will SFMSA needto get to meet the projected shortfall? Support your recommendationand present your findings in a way that the director willunderstand. (40 points)
I have answered problem 1, the answer is in bold. I need helpanswering problem 2 and 3.
NIKE:
Need the following ratios to be calculated using the financial sheets copied at the bottom. Each ratio needs to be calculated using the information from 2016. Each ratio also needs to be broken down and illustrated by the step by step process. Finally, please include any and all observations for each ratio and analysis.
1) Common Size analysis
2) Common size vertical analysis & graph
3) Current Ratio
4) Quick Ratio
5) Cash Ratio
6) Inventory Turnover
7) Receivables Turnover
8) Total Asset Turnover
9) Fixed Asset Turnover
10) Gross profit margin
11) Operating Profit margin
12) Net profit margin
13) Return on total assets
14) return on equity
15) basic earning power
16) Deb/net worth ratio
17) debt ratio
18) DuPont System
19) Times-interest-earned
Balance Sheet:
Consolidated Balance Sheets - USD ($) $ in Millions | May 31, 2017 | May 31, 2016 |
Current assets: | ||
Cash and equivalents | $ 3,808 | $ 3,138 |
Short-term investments | 2,371 | 2,319 |
Accounts receivable, net | 3,677 | 3,241 |
Inventories | 5,055 | 4,838 |
Prepaid expenses and other current assets | 1,150 | 1,489 |
Total current assets | 16,061 | 15,025 |
Property, plant and equipment, net | 3,989 | 3,520 |
Identifiable intangible assets, net | 283 | 281 |
Goodwill | 139 | 131 |
Deferred income taxes and other assets | 2,787 | 2,422 |
TOTAL ASSETS | 23,259 | 21,379 |
Current liabilities: | ||
Current portion of long-term debt | 6 | 44 |
Notes payable | 325 | 1 |
Accounts payable | 2,048 | 2,191 |
Accrued liabilities | 3,011 | 3,037 |
Income taxes payable | 84 | 85 |
Total current liabilities | 5,474 | 5,358 |
Long-term debt | 3,471 | 1,993 |
Deferred income taxes and other liabilities | 1,907 | 1,770 |
Commitments and contingencies | ||
Redeemable preferred stock | 0 | 0 |
Shareholdersâ equity: | ||
Capital in excess of stated value | 8,638 | 7,786 |
Accumulated other comprehensive (loss) income | (213) | 318 |
Retained earnings | 3,979 | 4,151 |
Total shareholdersâ equity | 12,407 | 12,258 |
TOTAL LIABILITIES AND SHAREHOLDERSâ EQUITY | 23,259 | 21,379 |
Class A Convertible Common Stock | ||
Shareholdersâ equity: | ||
Common stock at stated value | 0 | 0 |
Class B Common Stock | ||
Shareholdersâ equity: | ||
Common stock at stated value | $ 3 | $ 3 |
Income Statement:
Consolidated Statements of Income - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Income Statement [Abstract] | |||
Revenues | $ 34,350 | $ 32,376 | $ 30,601 |
Cost of sales | 19,038 | 17,405 | 16,534 |
Gross profit | 15,312 | 14,971 | 14,067 |
Demand creation expense | 3,341 | 3,278 | 3,213 |
Operating overhead expense | 7,222 | 7,191 | 6,679 |
Total selling and administrative expense | 10,563 | 10,469 | 9,892 |
Interest expense (income), net | 59 | 19 | 28 |
Other (income) expense, net | (196) | (140) | (58) |
Income before income taxes | 4,886 | 4,623 | 4,205 |
Income tax expense | 646 | 863 | 932 |
NET INCOME | $ 4,240 | $ 3,760 | $ 3,273 |
Earnings per common share: | |||
Basic (in dollars per share) | $ 2.56 | $ 2.21 | $ 1.90 |
Diluted (in dollars per share) | 2.51 | 2.16 | 1.85 |
Dividends declared per common share (in dollars per share) | $ 0.70 | $ 0.62 | $ 0.54 |
Cash Flow Sheet
Consolidated Statements of Cash Flows - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Cash provided by operations: | |||
Net income | $ 4,240 | $ 3,760 | $ 3,273 |
Income charges (credits) not affecting cash: | |||
Depreciation | 706 | 649 | 606 |
Deferred income taxes | (273) | (80) | (113) |
Stock-based compensation | 215 | 236 | 191 |
Amortization and other | 10 | 13 | 43 |
Net foreign currency adjustments | (117) | 98 | 424 |
Changes in certain working capital components and other assets and liabilities: | |||
(Increase) decrease in accounts receivable | (426) | 60 | (216) |
(Increase) in inventories | (231) | (590) | (621) |
(Increase) in prepaid expenses and other current assets | (120) | (161) | (144) |
(Decrease) increase in accounts payable, accrued liabilities and income taxes payable | (364) | (889) | 1,237 |
Cash provided by operations | 3,640 | 3,096 | 4,680 |
Cash used by investing activities: | |||
Purchases of short-term investments | (5,928) | (5,367) | (4,936) |
Maturities of short-term investments | 3,623 | 2,924 | 3,655 |
Sales of short-term investments | 2,423 | 2,386 | 2,216 |
Investments in reverse repurchase agreements | 0 | 150 | (150) |
Additions to property, plant and equipment | (1,105) | (1,143) | (963) |
Disposals of property, plant and equipment | 13 | 10 | 3 |
Other investing activities | (34) | 6 | 0 |
Cash used by investing activities | (1,008) | (1,034) | (175) |
Cash used by financing activities: | |||
Net proceeds from long-term debt issuance | 1,482 | 981 | 0 |
Long-term debt payments, including current portion | (44) | (106) | (7) |
Increase (decrease) in notes payable | 327 | (67) | (63) |
Payments on capital lease and other financing obligations | (17) | (7) | (19) |
Proceeds from exercise of stock options and other stock issuances | 489 | 507 | 514 |
Excess tax benefits from share-based payment arrangements | 177 | 281 | 218 |
Repurchase of common stock | (3,223) | (3,238) | (2,534) |
Dividends â common and preferred | (1,133) | (1,022) | (899) |
Cash used by financing activities | (1,942) | (2,671) | (2,790) |
Effect of exchange rate changes on cash and equivalents | (20) | (105) | (83) |
Net increase (decrease) in cash and equivalents | 670 | (714) | 1,632 |
Cash and equivalents, beginning of year | 3,138 | 3,852 | 2,220 |
CASH AND EQUIVALENTS, END OF YEAR | 3,808 | 3,138 | 3,852 |
Cash paid during the year for: | |||
Interest, net of capitalized interest | 98 | 70 | 53 |
Income taxes | 703 | 748 | 1,262 |
Non-cash additions to property, plant and equipment | 266 | 252 | 206 |
Dividends declared and not paid | $ 300 | $ 271 | $ 240 |