Your company is deciding whether to invest in a new machine. The new machine will increase cash flow by $270,000 per year. You believe the technology used in the machine has a 10-year life; in other words, no matter when you purchase the machine, it will be obsolete 10 years from today. The machine is currently priced at $1,700,000. The cost of the machine will decline by $180,000 per year until it reaches $980,000, where it will remain.

If your required return is 16 percent, which year should you purchase the machine?

What is the NPV if you purchase the machine in the optimal year?

Hollister & Hollister is considering a new project. The project will require $622,000 for new fixed assets, $238,000 for additional inventory, and $42,000 for additional accounts receivable. Accounts payable are expected to increase by $175,000. The project has a 6-year life. The fixed assets are in the 5-year MACRS class. At the end of the project, the fixed assets can be sold for 20 percent of their original cost. The net working capital returns to its original level at the end of the project. The project is expected to generate annual sales of $975,000 and costs of $540,000. The tax rate is 34 percent and the required rate of return is 14 percent. What is the total cash flow in year 6 of this project?

I don't want the answer on excel. And it should give $486,385.25

Write a new MATLAB function as described in the following:

1. The new function will have three input parameters: f, W, C. 2. Parameter f will specify the frequency of the square wave. 3. The parameter W will specify the width of the single pulse as a number of sample periods. 4. The parameter C will specify the number of square wave cycles. 5. Calculate a number of samples, N, to run the simulation for both waveforms. 6. Create one signal that is a square wave of period 2W samples and lasts for a duration of C cycles. 7. Create a signal beginning with a single pulse of amplitude 1 and a width of W samples followed by N-W samples with amplitude of 0. 8. Plot time and frequency domain plots for each. Use subplots to show all four graphs on the screen at once, arranged the same way as in the reference lecture slide. Scale the plots as necessary so that the desired characteristics can be easily seen. Label the x-axis with the correct units of time/frequency. Run the new function with f=1000, W=20, and C=10.

1. Stanford Company has contracted to build for the City of New London a new courthouse. The estimated cost of the project is $6,000,000, and the contract price is $9,000,000. The courthouse took three years to complete as follows:

                                                2018                       2019                       2020
Costs to date                      $1,500,000           $4,000,000           $6,200,000
Cost to complete             $4,500,000           $2,200,000           $0

Amounts billed to date $1,400,000           $5,800,000           $9,000,000
Amounts collected to date
                                             $1,300,000           $4,300,000           $9,000,000

Determine the gross profit to be recognized for

                                         2018                           2019                   2020

• Submit a business proposal for a new business (A new "start-up" venture that you or a group of people are contemplating)
• Submit a new project proposal (Possibly one that you and/or your firm is working on now or recently completed)

Prepare a proposal using the requirements list below. The proposal should focus on solving a organizational problem and provide for cost savings and/or revenue-generation. I suggest that you use a project that you have or plan to propose to your organization or a start new business that already exist and that you would like to start someday. It is much easier to work with actual figures than to make up a fictitious company and researching what the possible figures might be. The proposal should include all (but is not limited to) the following information:

• Briefly describe the Business venture/project and its relationship to the organizational mission.
• If this is a new business, what is the legal structure (Partnership, Corporation or S Corporation)?
• What method of accounting (Cash method Vs Accrual method) will you use? Why?
• How will you price your product and/or products? What is the mark up on the product? What pricing strategy, Target Price and/or Cost Plus Price? Use this in the Sales Budget.
• You should explain if you are tracking cost using Job Order Cost system, Process Cost system, Operating Cost system, Activity Based cost system (for overhead) and/or a combination of the systems
• Create a 1year Master Budget for the business/project.
• Prepare Cash budget (and/or Cash Flow statement) and provide a brief analysis of cash flows from Operation, Investing and Financing activities (Cash flow statement analysis)
• Break Even Analysis, Target Profit and Margin of Safety in units and Sales Dollars for the Business/Project
• Discuss the Return on Investment and/or Economic Value Added for the business/program/project to measure its projected performance.
• What is the Business/Project's Payback Period, Accounting rate of return and Net Present Value?
• If capital equipment is involved, is there a lease or buy decision - (NPV analysis).
• If new a Business or Project, calculate and show the Present Value of the Business or Project using NPV analysis based on the expected future cash flows (possibly from Cash Budget or Cash flow statement).
• Do you require new personnel, if so complete and submit a brief job description?
• How will you fund this new program? Raising capital for the Business/project/program through funds internally (Retained Earning) to the company or externally via Bonds/Loans and/or Equity from investors.
• Evaluation business/project comparing following ratios with Industry and/or major competitor
  • Profitability and Total Asset Management by calculating the following ratios: Profit Margin, Asset Turnover and Return on Asset
  • Solvency by calculating the following ratios: Debt to Equity and Time Interest Earned
  • Liquidity by calculating the following ratios: Cash flow yield, Cash flow to Sales, Cash flow to assets and finally Free Cash Flow and Time Interest Earned
• Have a conclusion convincing financer/management to finance the Business/Project.

This write up document in Microsoft word document should be no more than 10 pages. The cover sheet should include the type of proposal you are submitting, the name of your team members (if applicable) and their role in the project. Second page should be an executive summary giving a brief description of the project and any information you find pertinent (maximum 250 words). Your write up should provide analysis and summary touching on the requirements of the project. You can have supporting documents in the appendix that will not be counted towards the 10 pages of write up.

Format is important, and you are expected to present the information in an attractive, professional manner. If your use references, please make sure they are cited either in the footnotes or at the end of the paper. A title page and a table of contents lends to the organization of the paper. The document must be double-spaced, and professionally prepared (i.e., using basic APA style and/or www.isiresearchsoft.com for bibliographic formatting resources) spell-checked, clearly organized, and clearly summarized, with accurate citations for all referenced work.

You may only use Microsoft Word or Excel to develop your paper; remember that you must show your calculations. Papers submitted in .pdf format are also acceptable.
If you include proprietary information from your organization, please mark your paper confidential to ensure that its contents will not be used as an example in future classes.

Lastly, please make sure that the project employs some form of financial statements, capital expenditure worksheets, and/or any other pertinent accounting support schedules that we will employ throughout this course. Every project that is submitted must have some numerical support and accounting schedules, not just a written analysis.

Option 1: Building a new refinery

The construction and installation of a new refinery will cost $22 million. In addition, a processing plant will also need to be constructed at a cost $6 million. This plant will need to be supplied with grinding machines, DMS flotation machines and other equipment at a total cost of $16 million. Kidman Resources’ current fleet of Haul trucks, water carts and dump trucks will meet the needs for this project, however until recently, the fleet has been earning a rental income of $120,000 per year.

Under the agreement with Tesla inc., the lithium mined is expected to generate a revenue of $15 million per year, which will increase by 2.8% per annum adjusted for rising costs. Due to the additional complexities involved with the construction and management of this new refinery, 5 new engineers (yearly salary per engineer $160,000) will replace 5 existing engineers (yearly salary per engineer $120,000). All other remaining labour force required is expected to cost $3 million per annum for the duration of the project.

For tax reasons you will expense the cost of the processing plant immediately. The cost for the construction and installation of the new refinery and associated machines and equipment will be depreciated over three years using the straight-line method. Due to the nature of the mining project, the machines and equipment will likely have a salvage value of $10 million at the end of three years. Finally, the required net working capital is $2 million.

Option 2: Outsourcing the supply of ore

Alternatively, Kidman Resources can contract BHP to supply the required ore to process into lithium hydroxide. Based on the required amount of lithium hydroxide, management has quoted a total cost of $28 million. BHP has however offered this rate on the condition that Kidman Resources pays 20% of the total cost in advance in the beginning of the year, with the remaining paid in equal instalments thereafter. Kidman Resources will process the ore into lithium hydroxide using existing facilities at an expected cost of $4.4 million per year.

Calculate NPV for option 1 and 2. Tax rate= 28%, discount rate= 10%

In case of big data there is a need of new data architecture, new storage approaches, new tools, new analytics methods and technique.

Select one:

a. True

b. False

2-

The Shopping Mall wants to group the products based on the data about their similar features, which of the following data mining approaches can be applied

Select one:

a. Association

b. Regression

c. Clustering

d. Classificiation

3-

A Excell spreedshed containing id number, names and marks of the student is example of

Select one:

a. Structured data

b. unstructured data

c. Semi Structured data

4-

The college wants to plan which courses to offer next semester, it must use

Select one:

a. Library data

b. last years registration data

c. Social media data

d. Alumni data

6-

A Manager of the ABC company wants to status of key Perfamance indicators, he must use

Select one:

a. Data warehousing

b. Dash board

c. Data mining

d. Spreadsheet

Norister Inc. is considering introducing a new product line. This will require the purchase of new fixed assets of $2.4 million. The company estimates that demand for the new product will be approximately 15,000 units per year, with a price per unit of $100. The variable cost of producing each unit of the product is $35, and fixed costs per year will be $100,000. Demand for the product is expected to remain constant for six years, after which both demand and production will cease, and the associated fixed assets will have no salvage value. Depreciation on the fixed assets will be straight-line to zero. The company’s marginal tax rate is 35%, and the required return on the project is 13%. Due to forecasting risk, the company estimates that price per unit, variable cost, fixed costs, and quantity sold could vary by ±10%, ±15%, ±5%, and ±10%, respectively. What is the project’s net present value in the best-case scenario?

Select one: a. $1,543,413 b. $1,353,424 c. $1,043,502 d. $368,020 e. $103,677

1. Stanford Company has contracted to build for the City of New London a new courthouse. The estimated cost of the project is $6,000,000, and the contract price is $9,000,000. The courthouse took three years to complete as follows:

                                                2018                       2019                       2020
Costs to date                      $1,500,000           $4,000,000           $6,200,000
Cost to complete             $4,500,000           $2,200,000           $0

Amounts billed to date $1,400,000           $5,800,000           $9,000,000
Amounts collected to date
                                             $1,300,000           $4,300,000           $9,000,000

Determine the gross profit to be recognized for

                                         2018                           2019                   2020

Record all journal entries necessary for 2018 below:

Assume that Stanford uses the completed contract method. Determine the amount of revenue and expense to be recognized in:
                                                2018                       2019                      2020

A group of 65 new substance abuse counselors were tested for their understanding of a new confidentiality procedure. The highest test score was a 92; the mean was 88 and the range was 6. The next day, a counselor who was absent took the test and scored a 100. Indicate whether adding the late counselor’s score to the rest of the scores will increase, decrease or likely not change the following descriptive measures.

Median

Variance

Range

Standard Deviation