Question Details

(Solved) Moores Familay Restaurant Financial Data Income & Expense Statement Sales Cost of Product Labor Benefits Utilities Loan Principle Repayments...


I need help with answering these 33 questions before i submit today.

Moores Familay Restaurant Financial Data
Income & Expense Statement
Sales
Cost of Product
Labor
Benefits
Utilities
Loan Principle Repayments
Insurance
Property Taxes
Services (accounting, trash, cleaning, etc.)
Other: SG&A, advertising, promostions
Total Costs
Earnings Before Interest, Income Taxes, & Depreciation (EBITD)
Interest on loan
Income Taxes
Depreciation on values
Earnings After Interest, Income Taxes, & Depreciation
Meals Sold
Average Meal Value Historic Performance (Old Business Mode
2009
2010
$1,794,000 $1,677,120
$485,000 $714,250
$298,600 $294,856
$46,269
$48,651
$58,500
$61,425
$35,000
$65,000
$7,560
$8,505
$20,000
$21,000
$6,800
$13,600
$957,729 $1,227,287
$836,271 $449,833
$234,156 $125,953
$602,115 $323,880
312,000.00 279,520.00
5.75
6.00 ormance (Old Business Model)
% Change
2011
2012
2009-2012
$1,635,750 $1,620,060
-9.70%
$784,963 $797,211
64.37%
$292,516 $330,772
10.77%
$48,265
$57,647
24.59%
$58,047
$67,721
15.76%
n/a
$100,000 $115,000 228.57%
$8,505
$9,072
20.00%
$25,000
$29,000
45.00%
$27,200
$35,360 420.00%
$1,344,496 $1,441,783
50.54%
$291,254 $178,277 -78.68%
n/a
$81,551
$49,918 -78.68%
n/a
$209,703 $128,359 -78.68%
261,720.00 249,240.00 -20.12%
6.25
6.50
13.04% Moores Familay Restaurant Financial Data
Budget Worksgheet
Sales
Cost of Product
Labor
Benefits
Utilities
Loan Principle Repayments
Insurance & Property Taxes
Services (accounting, trash, cleaning, etc.)
Other: SG&A, advertising, promostions
Total Costs
Earnings Before Interest, Income Taxes, & Depreciation (EBITD)
Interest on loan
Income Taxes
Depreciation on values
Earnings After Interest, Income Taxes, & Depreciation
Meals Sold
Average Meal Value 2013
$1,575,396
$697,211
$330,772
$79,872
$54,340
$0
$110,000
$41,051
$77,629
$1,390,875
$184,521
$3,500
$51,666
$71,176
$58,179
233,392
6.75 2014 (Present Day)
$1,696,296
$597,211
$340,695
$114,519
$50,644
$0
$110,000
$43,908
$84,771
$1,341,748
$354,548
$3,000
$99,273
$61,777
$190,497
242,328
7.00 2015 Budget Forecast
Answer to number 17
Answer to number 18
Answer to number 19
Answer to number 20
$58,241
$0
$110,000
Answer to number 21
$93,248
Answer to number 22
Answer to number 23
$3,000
#VALUE!
$61,177
#VALUE!
261,714
7.35 Moore's Family Restaurant
Assets & Liabilities as of 12/31/13
ASSETS
Cash
Accounts Receivable
Inventories
Prepaid Expenses
Total Current Assets $492,118.00
$29,000.00
$30,000.00
$2,000.00
$553,118.00 Building
Equipment
Fixtures $727,460.97
$14,500.00
$33,320.00
Total Fixed Assets Total Assets $775,280.97
$1,328,398.97 LIABILITIES
Accounts Payable
$57,432.00
Wages and Benefits Due
$16,516.59
Estimated Taxes and Fees
$6,013.00
Total Current Liabilities
$79,961.59
Long Term Loan
$70,000.00
Total Long-Term Liabilities
$70,000.00 Owner Equity
Total Liabilities and Owner Equity $1,178,437.38
$1,328,398.97 Assets & Liabilities projected to 12/31/14
ASSETS
Cash
Accounts Receivable
Inventories
Prepaid Expenses
Total Current Assets $589,118.00
$49,095.00
$30,000.00
$11,000.00
$679,213.00 Building
Equipment
Fixtures $760,000.00
$18,000.00
$35,500.00
Total Fixed Assets Total Assets $813,500.00
$1,492,713.00 LIABILITIES
Accounts Payable
$137,566.00
Wages and Benefits Due
$29,543.00
Estimated Taxes and Fees
$8,013.00
Total Current Liabilities
$175,122.00
Long Term Loan
$70,000.00
Total Long-Term Liabilities
$70,000.00 Owner Equity
Total Liabilities and Owner Equity $1,247,591.00
$1,492,713.00

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200160146.zip (25.37 KB)

Buy this answer for only: $18

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now