Create a 1-year projected forecast with one cutter employees

Assignment Help Financial Management
Reference no: EM131966265

Knowing, the old business adage, "it takes money to make money" you decide to pitch your business plan in the Salisbury University Entrepreneurship Competition with the hopes of enticing an investor. You plan is to present and ask for $100,000 in startup money but know any good investor will want to make sure a return is possible. After extensive research, you compile a list of information surrounding the three areas of expansion.

Research Details:

Fortunately, you have been in the paper business long enough to have some solid market knowledge. Your business goal is to increase efficiency and sales in such a way that puts your competitors out of business. With your knowledge and the insider information you have secured on your competitors, you decide to use the market values (not your individual company) to estimate sales. You manage to compile the following information on the three expansion areas to help you create your forecast and pitch this to potential investors:

Employees :

As a startup, you can't pay your employees a high salary but you hope to entice them with good working environment, a strong benefits package and time off.

You hope to start with three employees in addition to you - the principal owner. Each will work the paper cutter and provide additional business support.

You are planning on paying each of your employees $25.00 per hour or $20,800 per year. You estimate with salary, insurance, and benefits, each employee will cost you about $35,000 per year.

You know this is not a strong financial offer so you decide to sweeten the pot by offering a 4-day work week. You base this on the traditional 52 week working calendar.

It is true that many small business owners do not draw a salary for a number of years, but you can't do that - you have no other source of income. You are hoping your new cutter will allow you to take at least $60,000 this first year. As the business becomes secure, you are sure you will be able to pay yourself more.

New Location:

With the cities incentives to bring new manufacturing companies downtown, you were able to secure a deal for six dollars a square foot in a 1000 ft.² facility. Your rent of $6,000 per month allows you space to operate your paper cutter, house your new employees, and handle the day-to-day business. Your space will also work for expansion and you estimate it will last for the next many years.

Fortunately, your lease covers insurance, maintenance, and building taxes.

Paper, Cutter, & Production:

If you start buying your paper in reams (500 sheets), you can get a 10% discount on the markets average price.

While the cutter is much faster than scissors, it still takes a toll on your employee's wrist. You estimate that an employee can't cut for more than 4 hours each day. The cutter only needs one employee to run it.

A new paper cutter will allow a single employee to cut 2 reams per hour. This is much better than the 6 hours it would take to cut one ream by hand.

As the cutter is used the blade becomes dull. The manufacturer's recommendation is to change the blade every 1,000 sheets or 2 reams. Blades cost $5.00 to replace.

Based on the market and what you know of paper sales, you make the assumption that every bit of paper you produce, you can sell.

Cutter cost is $6000 for one

Average original square sale price is $3.76

Average original paper purchase price is $3.64

Even though your specialty item can demand a high price, you recognize the strength of your business lies in its core operation - original squares.

Other business expenses:

After talking to a lawyer and insurance agent, you estimate company insurance at $38.00 per month.

Business licenses and lawyer fees should run you about $2,000 each year.

You expect to spend the equivalent of $1 per ream on advertising and marketing.

Additional miscellaneous business expenses you hope to keep below $500 per month.

You expect to pay about 30% in taxes

Your cutter will depreciate over the course of 1 year - meaning it won't be worth anything at the end of the year.

You expect to pay 6.1% interest on your loan each year.

Assignment A: Create a 1-year projected forecast with one cutter and three employees.

Make sure your case has the following

Correct information in the Constants section

Formulas in the Production Calculations section

Formulas and/or cell references in the forecast section

Reference no: EM131966265

Questions Cloud

How the abridged pricing theory functions : How the abridged pricing theory functions give an example of using the capital asset pricing model and an example of using the abridged pricing theory.
The yield on 1-year bonds 1 year from now is : You know that 2-year Treasury notes yield 3.6% per year and 1-year treasuries yield 4.3% per year.
Discuss concepts of planning and human resource management : Organize the concepts of planning and human resource management essential to the study of public administration as it relates to political choice.
What amount will the insurance company pay for the damages : One evening he lost control of his vehicle, hitting a parked car and damaging a storefront along the street.
Create a 1-year projected forecast with one cutter employees : Create a 1-year projected forecast with one cutter and three employees. Make sure your case has the following. Correct information in the Constants section.
How can your firm mitigate that risk : List of some of the types of risk your firm (Kohl's Corporation) faces. What is the biggest one(s) it faces? How can your firm mitigate that risk?
What is the maximum annual fee that kristen should pay : What % increase in the number of pens sold is required for Kristen to make up for the lower margins?
What is the net advantage to leasing : It can borrow $4,800,000, the purchase price, at 10% and buy the tools, or it can make 3 equal end-of-year lease payments of $2,100,000 .
Determine the book value of klingons total assets today : Klingon Widgets, Inc., purchased new cloaking machinery three years ago for $3 million. The machinery can be sold to the Romulans today for $2.5 million.

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd