Reference no: EM131132719
Instructions Use the information below to complete the attached spreadsheet.
A complete budget worksheet for Hannah & Maggie Inc.
A budgeted Income Statement for the three-month period ending March 31, 2014.
A budgeted Balance Sheet for March 31, 2014.
Problem: Hannah & Maggie Inc.
Hannah & Maggie are independent recording artists who sell their music wholesale for a living. In December Hannah found a Neumann record cutting machine on sale for $25,000. The machine can be used to transfer digital music to vinyl records.
Hannah and Maggie think their new album would sound amazing (and sell well) as an LP, but they need a loan to purchase the machine. A local bank is agreeable, but requires both current (2013) and budgeted (3 months in 2014) financial statements.
Based on the following information from Hannah & Maggie, construct the banker's report using the excel spreadsheet provided (seriously, use the spreadsheet!).
Balance Sheet
|
|
2014 Sales Forecast
|
December 31, 2013
|
|
|
Cash
|
$19,200
|
|
January
|
29,600
|
A/R
|
22,000
|
|
February
|
34,400
|
Inventory
|
6,000
|
|
March
|
38,000
|
Fixed Assets
|
28,000
|
|
April
|
43,200
|
Total Assets
|
$75,200
|
|
May
|
31,200
|
|
|
|
|
|
A/P
|
$6,400
|
|
|
|
Accrued Credit Fees
|
330
|
|
|
|
Common Stock
|
16,000
|
|
|
|
Retained Earnings
|
52,470
|
|
|
|
Total Liab& Equity
|
$75,200
|
|
|
|
Additional Information:
a. Everyone who buys H&M's music pays with a credit card. H&M collect 40% in the month of the sale and 60% in the month after the sale.
b. The credit card sales also mean that H&M incur a 1.5% sales fee. The sales fee is due one month after the sale.
c. The cost of sales is 35% of (current month) sales.
d. To make sure they don't run out of music to sell at shows, Hannah & Maggie plan to maintain inventory at the sales requirements for the next two months' budgeted sales.
e. Hannah & Maggie use a credit card for all their purchases; the duo pays off their balance in full the following month.
f. Hannah & Maggie pay their manager 3% of sales each month.
g. In addition to the variable management cost, the duo incurs fixed expenses of $5,000 per month, $500 of which is for depreciation of fixed assets.
Comments: The biggest complexity is that the desired ending inventory is for two full months (not 10% or 50% or next month). The structure has been developed for you to calculate the cost of the desired ending inventory for the two months. Do not worry if the same dollar amount is used the following month. Each month should be treated as a stand-alone, not affected by the other months.
What are the roles of the corrections organization
: In your written assignment this week, describe what factors may cause probation to be successful or not. What are the roles of the corrections organization, the probation officer, and the offender in the outcome of the probationary period
|
Are there disadvantages in user involvement
: A common approach to system testing is to test the system until the testing budget is exhausted and then deliver the system to customers. Discuss the ethics of this approach for systems that are delivered to external customers.
|
Estimate the volume of the raft and the mass of co2
: Estimate the volume of the raft and the mass of CO2 in grams in the prototype cartridge
|
What is meant by the term health care costs
: What do the statistics tell us of who are homeless and what are their barriers to healthcare? What is meant by the term "health care costs"? Describe the three different meanings of the term 'cost.'
|
A complete budget worksheet for hannah
: Hannah & Maggie are independent recording artists who sell their music wholesale for a living. In December Hannah found a Neumann record cutting machine on sale for $25,000. The machine can be used to transfer digital music to vinyl records.
|
Why controlling violence without state difficult and costly
: Bates discusses a fascinating example of "peace without a state" in his discussion of the Nuer (43-45). He argues that the Nuer constructed a society that provided some peace without the threat of state violence, but it came at a great cost?
|
Determine the reactions on the beam at its support a
: Determine the reactions on the beam at its support A in terms of the compression CA, shear VA, and bending moment MA.
|
Define the concepts of motivation
: In your own words define the concepts of motivation, and describe several major theories of motivation
|
Write a review of the article
: Write a review of the article: include an overview of the main point(s) and your thoughts on the information
|