Free

Course project week 1 - Coursework Example

Comments (0) Cite this document
Summary
The restaurant has a design which is structured to satisfy the customer from all backgrounds. The restaurant is a world in itself and our customers can feel…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.8% of users find it useful
Course project week 1
Read TextPreview

Extract of sample "Course project week 1"

Peter Geo’s Restaurant Budget Proposal for [Five Years] BUSN-278 [Term] DeVry Table of Contents Section SubsectionTitle
Page Number
1.0
Executive Summary
2.0
Sales Forecast
2.1
Sales Forecast
2.2
Methods and Assumptions
3.0
Capital Expenditure Budget
4.0
Investment Analysis
4.1
Cash Flows
4.2
NPV Analysis
4.3
Rate of Return Calculations
4.4
Payback Period Calculations
5.0
Pro Forma Financial Statements
5.1
Pro Forma Income Statement
5.2
Pro Forma Balance Sheet
5.3
Pro Forma Cash Budget
6.0
Works Cited
7.0
Appendices
7.1
Appendix 1: [description]
7.2
Appendix 2:
[description]
The Papa Geo’s restaurant is an inviting restaurant which holds a comfortable and enjoyable environment both in and out. The restaurant has a design which is structured to satisfy the customer from all backgrounds. The restaurant is a world in itself and our customers can feel the same when they connect with exterior foundation, décor, theme and ambience of the restaurant. The restaurant has a custom made kitchen, unique dining area and intriguing grilling area. By offering an energy filled service oriented atmosphere the restaurant aims at delivering a fun filled dining experience to its customers.

The budget supports the restaurant by giving it a standard financial plan to follow. The budget sets out a financial plan and gives figures which the restaurant can rely on. The expected future results of the restaurant regarding can be analyzed from budget proposal of an organization.
The sales forecast section is an overview of the expected sales projection of the restaurant .In this section, one can view the expected sales for the restaurant over a five year period of time.
2.1 Sales Forecast
The sales are expected to rise with each consecutive year because the restaurant has a marketing agenda which allow expanding the potential target market of the country.
Year 1
Year 2
Year 3
Year 4
Year 5
Sales
1,200,000
2,400,000
2,500,000
2,700,000
3,00,000
2.2 Methods and Assumptions
The sales forecast was arrived by conducting a survey on restaurants which work in the same locality.
2015
Capital Expenditures Budget
Equipment, Land, Buildings, etc
$1,00,000
Labor
$12,000
Subcontractors/Consutants
$15,000
Direct Materials
$40,000
Other Capitalizable Costs
$ 22,100
General and Administrative/Overhead
$13,000
Total Capital
$202100
Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.
4.2 NPV Analysis
Interest rate
10%
Year
0
1
2
3
Cash flow
(600)
200
200
500
PV factor
100%
91%
83%
75%
PV of cash flow
(600)
182
165
376
Cumulative PV
(600)
(418)
(253)
123
Net Present Value
123
Provide a screenshot of your Excel NPV analysis here, and describe its highlights.
4.3 Rate of Return
Year
0
1
2
3
4
5
Cash flows
-$75,000
$20,000
$20,000
$20,000
$20,000
$20,000
4.4 Payback Period
Payback Period Analysis
Undiscounted Payback Period Analysis




Projected




Year 1
Year 2
Year 3
Year 4
Year 5
Undiscounted Net Cash Flow
$ (200,000)
$ 40,000
$ 60,000
$ 75,000
$ 100,000
$ 125,000
Cumulative Net Cash Flow
(160,000)
(100,000)
(25,000)
75,000
200,000
Positive Cash Flow?
FALSE
FALSE
FALSE
TRUE
TRUE
Undiscounted Payback Period
4
First Year Positive
Partial Year Payback Period
3.25
Actual Number of Years
Partial Year Payback Period (One Cell)
3.25
Using arrays and index
Discounted Payback Period Analysis
Discount Rate
10.0%




Projected




Year 1
Year 2
Year 3
Year 4
Year 5
Undiscounted Net Cash Flow
$ (200,000)
$ 36,364
$ 49,587
$ 56,349
$ 68,301
$ 77,615
Cumulative Net Cash Flow
(163,636)
(114,050)
(57,701)
10,600
88,216
Positive Cash Flow?
FALSE
FALSE
FALSE
TRUE
TRUE
Undiscounted Payback Period
4
First Year Positive
Partial Year Payback Period
3.84
Actual Number of Years
Partial Year Payback Period (One Cell)
3.84
Using arrays and index
5.1 Pro Forma Income Statement
Income Statements
(in thousands)
,
2015
Revenue
$ 16,195
Operating expenses:
Cost of revenue
3,139
Research and development
2,196
Sales and marketing
2,806
General and administrative
938
Total operating expenses
9,079
Operating income
7,116
Other income
114
Income before income taxes
7,230
Provision for income taxes
1,820
Net income
$ 5,410
Earnings per share:
Basic
$ 0.63
Diluted
$ 0.62
Weighted average shares outstanding:
Basic
8,614
Diluted
8,695
Cash dividends declared per common share
$ 0.16
5.2 Pro Forma Balance Sheets
(in thousands)
September 30,
2015
Assets
Current assets:
Cash and cash equivalents
$ 8,161
Short-term investments (including securities loaned of $683 and $62)
36,012
Total cash, cash equivalents, and short-term investments
44,173
Accounts receivable, net of allowance for doubtful accounts of $312 and $375
9,646
Inventories
1,242
Deferred income taxes
2,344
Other
2,176
Total current assets
59,581
Property and equipment, net of accumulated depreciation of $8,942 and $8,629
7,771
Equity and other investments
9,211
Goodwill
12,471
Intangible assets, net
1,077
Other long-term assets
1,429
Total assets
$ 91,540
Liabilities and stockholders equity
Current liabilities:
Accounts payable
$ 3,654
Short-term debt
1,000
Accrued compensation
2,252
Income taxes
2,136
Short-term unearned revenue
12,767
Securities lending payable
909
Other
3,139
Total current liabilities
25,857
Long-term debt
9,665
Long-term unearned revenue
1,152
Deferred income taxes
540
Other long-term liabilities
7,384
Total liabilities
44,598
Commitments and contingencies
Stockholders equity:
Common stock and paid-in capital - shares authorized 24,000;
outstanding 8,562 and 8,668
61,935
Retained deficit, including accumulated other comprehensive income
of $1,519 and $1,055
(14,993)
Total stockholders equity
46,942
Total liabilities and stockholders equity
$ 91,540
5.3 Pro Forma Cash Budget.
(in thousands)









Three Months Ended September 30,



2010
2009





Operations



Net income
$ 5,410

Adjustments to reconcile net income to net cash from operations:


Depreciation, amortization, and other noncash items
694

Stock-based compensation
Stock-based compensation expense
528

Net recognized losses (gains) on investments and derivatives
Net recognized gains on investments and derivatives
(29)

Excess tax benefits from stock-based compensation
(5)

Deferred income taxes
(148)

Deferral of unearned revenue
5,881

Recognition of unearned revenue
(6,862)

Changes in operating assets and liabilities:


Accounts receivable
3,674


Inventories
(468)

Other current assets
208

Other long-term assets
62

Other current liabilities
Accounts payable
(400)


Other current liabilities
(911)

Other long-term liabilities
560


Net cash from operations
8,194
Financing


Short-term borrowings, maturities of 90 days or less, net
814

Proceeds from issuance of debt, maturities longer than 90 days
4,721

Repayments of debt, maturities longer than 90 days
(814)

Common stock issued
177

Common stock repurchased
(4,399)

Common stock cash dividends paid
(1,118)

Excess tax benefits from stock-based compensation
5

Other
(25)


Net cash used in financing
(639)
Investing


Additions to property and equipment
(564)

Acquisition of companies, net of cash acquired
0

Purchases of investments
(7,417)

Maturities of investments
870

Sales of investments
1,427

Securities lending payable
727


Net cash used in investing
(4,957)
Effect of exchange rates on cash and cash equivalents
58
Net change in cash and cash equivalents
2,656
Cash and cash equivalents, beginning of period
5,505
Cash and cash equivalents, end of period
$ 8,161











Fig 1 : Sales and Profit Graph Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Course project week 1 Coursework Example | Topics and Well Written Essays - 250 words”, n.d.)
Course project week 1 Coursework Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/business/1696707-course-project-week-1
(Course Project Week 1 Coursework Example | Topics and Well Written Essays - 250 Words)
Course Project Week 1 Coursework Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/business/1696707-course-project-week-1.
“Course Project Week 1 Coursework Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/business/1696707-course-project-week-1.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Course project week 1

Business Law Course Project 1 Rubric

...degree. In some cases, there are specially designed courses for the magistrates and these can be acquired from justice colleges and upon fulfilling these requirements, the Minister of justice has the duty to appoint the magistrates. Introduction to the interviewee My interviewee is a law student and he has hopes of joining the legal profession as a magistrate once he successfully completes his studies. As such, this information has been specifically designed to gather the views of the interviewee with regards to his expectations in this legal career. Do you like this legal career? Which kind of court do you wish to work for? Can you preside over criminal cases? Is there fairness in passing a judgment? Do you think that...
6 Pages(1500 words)Essay

Course project part 1

... during the year. A corrected return on assets can be obtained by averaging the year 1 and year 2 assets in the computation. With an average asset of $1,447,000, the return on sales would be 8.29 percent instead of 6.33 percent but it is still lower than the previous years level. The growth in net profit margin markedly failed to keep pace with the growth in sales. The return on stockholders equity was slightly lower than the previous years. Judged against the industrys profitability benchmarks, the company is competitive, if not slightly better. What is a bit disappointing is that the superiority in terms of sales did not result in significantly better bottom-line performance. Liquidity The current ratio in the previous year... was a...
2 Pages(500 words)Coursework

Lesson 11 - Course Project 1

...s 657 26 November Project Ethics Challenge and Communicating in Practice Budgets put into perspective the future financial goals of a firm. Divergent views on budget-making process obfuscate budget-making process through ethical and communication in practice issues. Adverse budget situations sometimes require urgent and prudent unraveling for the budget to deliver on its broad mandate of keeping the organization strategically alert. The purpose of this paper is to highlight budgetary on ethics and communication in practice, and their possible resolutions. Ethics Challenge 1. a) Why Atkins and Granger behave in this manner, and the expected benefits of budgetary slack A budgetary slack is a premeditated...
4 Pages(1000 words)Essay

Course project week 1

... of Affiliation Hydraulic Fracturing Hydraulic fracturing refers to a well-simulated procedure that is applied when undertaking a maximum extraction of resources like natural gas, oil, water and even geothermal energy found deep beneath the earth’s surface. With regard to gas and oil, this process finds its use in creating a free movement of the said resources from the rock pores all the way to the production wells. A slight difference occurs between oil fracturing and gas fracturing, in that gas requires prolonged fracturing session unlike oil. () The fracturing process involving pumping of fluids usually made up of chemicals... of Affiliation Hydraulic Fracturing Hydraulic fracturing refers to a well-simulated procedure that is applied when ...
1 Pages(250 words)Assignment

Week 6 project 9:1

...Data centre Data centre A data centre refers to a centralized repository, whether virtual or physical that is used for data storage, dissemination as well as management. In the data centre, information is usually organized around a particular subject. A data centre is normally used in housing computer systems which are utilized in data storage and transmission (Banks, 2005). This study focuses on a data centre in a fictitious company by the name Sharp Investigators Company. Due to the high level of data that the organization receives to its systems, it needs to develop a well integrated data centre from where information and communication flows. It is worth noting that data and information that is transmitted across departments... centre Data ...
2 Pages(500 words)Assignment

Financial Accounting Week 8 Course Project

...ESSAY: FINANCIAL ACCOUNTING; DEPRCIATION Depreciation It can be defined as the decrease in the monetary value of an asset over a period of time of its usage, wear and tear or due to obsolescence. This decrease can be caused by a variety of factors such as unfavourable market conditions and poor economic situation of a country. Any business therefore usually accounts for the depreciation costs in their books and this estimation of depreciation is useful for the company estimating the property value for tax purposes. The mostly common used depreciation methods are straight-line, units-o-production, sum-o-years digits and double- declining balance and accelerated depreciation methods. This paper tends to illustrate the different... FINANCIAL...
3 Pages(750 words)Assignment

Financial Accounting Week 10 Course Project

...ESSAY: FINANCIAL ACCOUNTING: COMPENSATION STRATEGY ON DIVIDENDS & STOCK OPTIONS Date Compensation strategy This is regarded as a very important and vital part of human resource management in any organisation and it defines the organisation’s position on the job market. Compensation can be defined as payment of wages and salaries to employees of a company as well as other benefits such as dividends that have accrued from the sales. The amount of compensation in a company depends on the company’s financial strength and base. To a large extent, the compensation strategy of a company affects its operational costs. Good compensation strategy is therefore very important in an organisation as it helps... FINANCIAL...
3 Pages(750 words)Assignment

Financial Accounting Week 12 Course Project

...and management in case an organization consistently reports the net income that exceeds the cash flows. The shareholders and management might want to identify causes of non-cash income and find out if these will bring serious issues with the company (Kimmel, Weygandt & Kieso, 2011). If the shareholders and management realize that there is cash shortage then the company might face bankruptcy, whereas when there is excess cash then the organization needs to increase its investment, pay down their debts, distributes the dividends, or increase the executive salaries. Reference 1. (2006). Financial Accounting and Reporting Standards for Private Entities. Accounting Horizons, 20(2), 179-194. 2. Kimmel, P. D., Weygandt, J. J.,...
4 Pages(1000 words)Assignment

Course Project

...on strengths and weaknesses would likely be more effective if it came on an ongoing basis, rather than in an annual or semi-annual performance appraisal”.Then the mission, goals and values will be instructed to the employee in training sessions. Later, the performance of the employees will be studied to see the effectiveness of the training and development program. As per (People Stream) “Performance Management is used to ensure that employees activities and outcomes are congruent with the organisations objectives and entails specifying those activities and outcomes that will result in the firm successfully implementing the strategy”. Thus the employee performance appraisal project will bring the company back to it...
1 Pages(250 words)Essay

Course project

...December 29, Accounting Cycle Introduction Several nonprofit organizations normally implement humanitarian activities. The paper delves on one of the Qatar’s well known nonprofit organizations. The paper focuses on the company’s financial reports. The company’s financial report adheres to IFRS accounting standards. Non Profit Organization The Qatar Red Crescent Society is the Qatar branch of the global Red Cross nonprofit organization. The company survives on donations, qualifying it as non-profit humanitarian organization (Table 1). The organization is not a branch or part of the government’s structure. The organization delivers fast humanitarian help and support to communities within the Qatar community. The same...
2 Pages(500 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Coursework on topic Course project week 1 for FREE!

Contact Us