On 1 January 2012, Rose Tremayne opens a bank account in the name of her new trading business, Rose Tremayne Trading (RTT). She puts £112,000 of her own money into the business bank account. The following is a summary of transactions during 2012:
(1) RTT takes out a short-term bank loan of £45,000 cash.
(2) RTT buys non-current assets at the start of January at a cost of £72,000 paying cash.
(3) Buys inventory of £60,000, paying cash.
(4) Inventory costing £48,000 is sold on credit for £72,000.
(5) Purchases inventory on credit for £84,000.
(6) Inventory costing £6,000 is sold for £9,000 cash.
(7) RTT purchases a 12 month insurance policy on April 1 for £4,000 providing cover until March 31 2013.
(8) RTT purchases two lots of land for £60,000 (ie £30,000 per lot). The purchase price of £60,000 is paid after RTT takes out a ten year loan of £34,000.
(9) Sells one of the lots of land for £33,000 cash.
(10) RTT pays rent of £15,000 for the first nine months of 2012 but owes rent of £5,000 on 31 December 2012.
(11) Inventory costing £69 000 is sold for £103,000 cash.
(12) Wages for the period amounting to £30,000 are paid in full.
(13) RTT pays off £15,000 of its short term bank loan.
(14) RTT pays total interest of £4,000 for the long-term bank loan for 2012.
(15) Customers pay £30,000 of cash owing.
(16) RTT pays its trade creditors £48,000.
(17) The equipment purchased for £72,000 at the start of January has an expected useful life of four years and an expected scrap value of zero. Assume straight-line depreciation is to be charged on these assets.
(a) Prepare a balance sheet for RTT as at 31st December 2012.
(b) Prepare an income statement for RTT for 2012 and briefly comment on RTT's performance during 2012.
(c) Prepare a cash flow statement for RTT for 2012.
Ballpark Concessions currently sells hot dogs. During a typical month, the stand reports an operating profit of $9,000 with Revenues of $50,000, fixed costs of $21,000, and variable costs of $0.64 per hot dog.
Next year, the company plans to start selling nachos for $3 per unit. Nachos will have a variable cost of $0.72 and new equipment and personnel to produce nachos will increase monthly fixed costs by $8,808. Initial sales of nachos should total 5,000 units. Most of the nacho sales are anticipated to come from current hot dog purchasers, therefore, monthly sales of hot dogs are expected to decline to $20,000.
(a) Determine the monthly contribution margin and variable costs before adding nachos.
(b) Determine the monthly breakeven sales in units before adding nachos.
(c) Determine the monthly breakeven quantities during the first year of nachos sales, assuming constant sales mix of 1 hotdog and 2 units of nachos.© BrainMass Inc. brainmass.com October 25, 2018, 10:04 am ad1c9bdddf
This response provides guidelines on breaking even, creating a balance sheet, an income statement, and a statement of cash flows.
Prepare a Balance Sheet, Income Statement, Cash Flows, TVM
See attached file for proper format.
Consider the following financial data for a company (all figures in thousands of dollars except stock price and # of shares):
Balance Sheet Data 12/31/2010 12/31/2009
Cash & Equivalents 500 100
Accounts Receivable 220 200
Inventories 1,000 1,100
Total Fixed Assets 10,750 10,000
Accumulated Depreciation 6,150 6,000
Net Fixed Assets 4,600 4,000
Accounts Payable 400 350
Accruals 70 100
Notes Payable (<1 year) 1,200 1,000
Long Term Debt 2,000 1,700
Common Stock 1,000 1,000
Retained Earnings 1,250
Stock price $30.00 $25.00
# of shares 100,000 100,000
Income Statement Data (2010)
Operating expenses excluding depreciation 7,500
Interest expense 120
Income taxes paid 830
Dividends paid 1,000
Construct a complete balance sheet for end of 2009 and 2010, a complete 2010 income statement, and a complete 2010 statement of cash flows. Also, calculate free cash flow for 2010.
1. Compute the following ratios for the financial statements above (use
12/31/2010 balance sheet ratios):
Return on Sales (ROS)
Return on Assets (ROA)
Return on Equity (ROE)
Times interest earned
Quick (acid test)
Price to earnings (P/E)
Market to book
2. Solve the following TVM problems (you may use formulas, a calculator, or Microsoft Excel):
a. How much would I need to deposit today in an account earning 10% per year in order to accumulate $10,000 after 5 years? What if my interest was compounded monthly?
b. If I deposit $100 in an account earning 10% per year, how much will my deposit be worth after 5 years? What if we had the same problem but interest is compounded monthly?
c. How much would I have in my retirement account if I deposited $2000 each year for 35 years and I earned 10% on my savings? What about $4,000? Instead, what if I made
monthly deposits of $166.67? How about monthly deposits of $333.33?
d. How much could I afford to borrow for a home if I can make monthly payments of
$12,000 per year for 30 years at 8%? What about monthly payment of $1,000? What if I
wanted to know what my monthly payments would be a $20,000 car loan over five years