NEW PROJECT ANALYSIS
You must evaluate a proposal to buy a new milling machine. The base price is $186,000, and shipping and installation costs would add another $18,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $65,100. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $7,500 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $40,000 per year. The marginal tax rate is 35%, and the WACC is 11%. Also, the firm spent $5,000 last year investigating the feasibility of using the machine.
What is the initial investment outlay for the machine for
capital budgeting purposes, that is, what is the Year 0 project
cash flow? Round your answer to the nearest cent.
$
What are the project's annual cash flows during Years 1, 2, and 3? Round your answer to the nearest cent. Do not round your intermediate calculations.
Year 1 $
Year 2 $
Year 3 $
In: Finance
Both Government and Opposition in New Zealand acknowledge that New Zealand needs to reduce its greenhouse gas emissions. To guide purchasing decisions of New Zealanders, government proposed to subsidise the price of imported electric and hybrid vehicles by up to NZ$8,000 and tax the import of vehicles with the highest greenhouse gas emission by up to NZ$3,000.[1]
Julie-Anne Genter says, “These policies are about making cleaner vehicles a realistic option for more New Zealand households and businesses.”[2]
Lawrence Yule responds “National supports incentivising people to buy electric vehicles, providing their lifestyle can accommodate them. From the surface this looks like a concept that is worth exploring, I have found however after investigation that it is unlikely to work.”[3]
The Ministry of Transport notes that, “New Zealand is well placed to benefit from electric vehicles. More than 80 percent of electricity is generated from renewable sources and there is enough supply for widespread adoption of EVs. Even if every light vehicle was electric, there is sufficient generation capacity to charge these provided the majority are charged at off-peak times.”[4]
Given what you understand about price elasticity of demand and supply, explain why electric vehicle prices continue to be so high in New Zealand. Use a suitable diagram to illustrate your answer.
Given what you understand about price elasticity of demand and supply, explain how the proposed "feebate" policy will affect consumer purchasing decisions of electric vehicles and vehicles with high greenhouse gas emissions ("gas guzzlers"). Use a suitable diagram to illustrate your answer.
Either using the same diagram, or a new one, explain the impact of the feebate policy on price in the two market segments. Explain how the benefit of the subsidy and the burden of the tax is likely to be shared between the consumers and vehicle importers. What impact would you expect the feebate policy to have on the price and quantity demanded of electric vehicles and gas guzzlers? What are the advantages to society of lowering the price of electric vehicles and increasing that of gas guzzlers? What are the disadvantages?
Based on your discussion, do you think the government’s intervening in the market of imported vehicles will be beneficial for society?
In: Economics
Suppose that new machines cost $504. The marginal benefit from new machines is: MB = 246 – 6K, where K is the number of machines purchased. The depreciation rate is 12%, the dividend yield is 6%, and the corporate tax rate is 35%. What would be the marginal cost of each dollar of machinery investment in the following situations?
a. Firms are allowed to expense the machine, and there is no tax credit
b. Firms are allowed to depreciate the machine over 5 years and use the dividend yield (6%) to discount depreciation allowances. Firms are also allowed an 8% investment tax credit (i.e. 8% of the amount invested).
In: Accounting
ANALYSIS An Australian manufacturing company is keen to develop new products and develop new product line of shoes so that the company can expand into Asian markets more than before. The data have been collected for 99 products from the market. The data are in an excel file named “SHOES”. The file includes: PRICE: Price of the shoes in dollars. GENDER: 1 for Female product and 2 for Male product. COUNTRY: the country in which the shoes is produced: 1 made in Thailand, 2 made in Singapore and 3 made in China. COST: Production cost of the shoes in dollars.
questions:
QUESTIONS Part 1: 1. Construct a pie chart for numbers of men and women shoes. Construct a pie chart for numbers for the three countries- Thailand, Singapore and China. Present your findings.
2. Construct a cross-classification table of frequencies between gender and country. Plot a vertical bar chart of frequency (Y variable) and gender (X variable), then group the bar charts of genders for three countries and comment on the relationship between gender and country
3. Determine if average prices for female shoes is less than average prices for male shoes. Compare the result with part 2 question
1. Does the result confirm your previous findings? (Follow the hypothesis testing steps, 0.05 level of significance, assuming “equal variances” of populations).
4. Using a scatter graph of price (Y variable on vertical axis) and production cost (X variable, horizontal axis), comment on the relationship between price and cost.
| COST | GENDER | COUNTRY | PRICE |
| 177 | 1 | 1 | 395 |
| 143 | 1 | 1 | 400 |
| 163 | 1 | 1 | 304 |
| 186 | 1 | 1 | 274 |
| 124 | 1 | 1 | 371 |
| 43 | 1 | 1 | 355 |
| 112 | 1 | 1 | 154 |
| 186 | 1 | 1 | 261 |
| 124 | 1 | 1 | 258 |
| 43 | 1 | 1 | 280 |
| 112 | 1 | 1 | 240 |
| 186 | 1 | 1 | 314 |
| 124 | 1 | 1 | 273 |
| 112 | 1 | 1 | 366 |
| 265 | 1 | 1 | 372 |
| 185 | 1 | 1 | 353 |
| 223 | 2 | 1 | 314 |
| 213 | 2 | 1 | 294 |
| 183 | 1 | 1 | 222 |
| 173 | 1 | 2 | 182 |
| 143 | 1 | 2 | 161 |
| 143 | 1 | 2 | 193 |
| 163 | 1 | 2 | 260 |
| 133 | 1 | 2 | 198 |
| 207 | 1 | 2 | 215 |
| 265 | 1 | 1 | 353 |
| 133 | 2 | 1 | 386 |
| 123 | 2 | 1 | 303 |
| 29 | 2 | 1 | 225 |
| 29 | 2 | 1 | 171 |
| 193 | 2 | 1 | 291 |
| 183 | 2 | 1 | 350 |
| 139 | 2 | 1 | 315 |
| 133 | 1 | 2 | 308 |
| 73 | 1 | 2 | 156 |
| 83 | 1 | 2 | 313 |
| 159 | 1 | 2 | 364 |
| 188 | 1 | 2 | 192 |
| 139 | 1 | 2 | 151 |
| 89 | 1 | 2 | 390 |
| 75 | 1 | 2 | 211 |
| 69 | 1 | 2 | 306 |
| 75 | 1 | 2 | 210 |
| 69 | 1 | 2 | 334 |
| 55 | 1 | 2 | 247 |
| 55 | 1 | 3 | 341 |
| 55 | 1 | 3 | 238 |
| 41 | 1 | 3 | 299 |
| 49 | 1 | 3 | 183 |
| 51 | 1 | 2 | 200 |
| 45 | 1 | 2 | 271 |
| 65 | 1 | 2 | 350 |
| 65 | 1 | 2 | 361 |
| 43 | 1 | 2 | 250 |
| 43 | 2 | 2 | 244 |
| 185 | 2 | 2 | 274 |
| 185 | 2 | 2 | 388 |
| 183 | 2 | 2 | 348 |
| 117 | 2 | 2 | 163 |
| 111 | 1 | 2 | 172 |
| 177 | 1 | 2 | 399 |
| 97 | 2 | 2 | 360 |
| 69 | 2 | 2 | 244 |
| 57 | 2 | 2 | 233 |
| 65 | 2 | 2 | 319 |
| 36 | 2 | 2 | 337 |
| 38 | 1 | 3 | 259 |
| 34 | 1 | 3 | 361 |
| 36 | 1 | 3 | 381 |
| 183 | 2 | 3 | 323 |
| 38 | 2 | 3 | 231 |
| 138 | 2 | 3 | 205 |
| 199 | 2 | 1 | 289 |
| 243 | 2 | 1 | 297 |
| 163 | 2 | 1 | 356 |
| 252 | 2 | 1 | 345 |
| 223 | 2 | 1 | 298 |
| 213 | 2 | 1 | 285 |
| 153 | 2 | 1 | 311 |
| 159 | 2 | 1 | 269 |
| 188 | 2 | 1 | 340 |
| 36 | 2 | 3 | 276 |
| 46 | 2 | 3 | 373 |
| 126 | 2 | 3 | 287 |
| 66 | 2 | 3 | 367 |
| 48 | 2 | 3 | 157 |
| 116 | 1 | 3 | 155 |
| 193 | 1 | 3 | 335 |
| 183 | 1 | 3 | 367 |
| 139 | 1 | 3 | 345 |
| 117 | 2 | 3 | 153 |
| 111 | 2 | 3 | 396 |
| 69 | 2 | 3 | 277 |
| 66 | 2 | 3 | 246 |
| 175 | 2 | 3 | 352 |
| 155 | 2 | 3 | 380 |
| 74 | 2 | 3 | 278 |
| 66 | 2 | 3 | 153 |
| 175 | 2 | 3 | 209 |
E
In: Statistics and Probability
ANALYSIS An Australian manufacturing company is keen to develop new products and develop new product line of shoes so that the company can expand into Asian markets more than before. The data have been collected for 99 products from the market. The data are in an excel file named “SHOES”. The file includes: PRICE: Price of the shoes in dollars. GENDER: 1 for Female product and 2 for Male product. COUNTRY: the country in which the shoes is produced: 1 made in Thailand, 2 made in Singapore and 3 made in China. COST: Production cost of the shoes in dollars.
questions:
1. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation, for
prices for men and women shoes, separately. Compare the figures and explain that what
conclusions you can draw from these analyses? Draw a box and Whisker plot for men and
female shoes prices and comment on the shape of the graph.
2. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation for
prices for the three countries – Thailand, Singapore and China, separately. Compare the figures
and explain what conclusions you can draw from these analyses? Draws a Box and Whisker
plot for each country and comment on the shape of the graph.
| COST | GENDER | COUNTRY | PRICE |
| 177 | 1 | 1 | 395 |
| 143 | 1 | 1 | 400 |
| 163 | 1 | 1 | 304 |
| 186 | 1 | 1 | 274 |
| 124 | 1 | 1 | 371 |
| 43 | 1 | 1 | 355 |
| 112 | 1 | 1 | 154 |
| 186 | 1 | 1 | 261 |
| 124 | 1 | 1 | 258 |
| 43 | 1 | 1 | 280 |
| 112 | 1 | 1 | 240 |
| 186 | 1 | 1 | 314 |
| 124 | 1 | 1 | 273 |
| 112 | 1 | 1 | 366 |
| 265 | 1 | 1 | 372 |
| 185 | 1 | 1 | 353 |
| 223 | 2 | 1 | 314 |
| 213 | 2 | 1 | 294 |
| 183 | 1 | 1 | 222 |
| 173 | 1 | 2 | 182 |
| 143 | 1 | 2 | 161 |
| 143 | 1 | 2 | 193 |
| 163 | 1 | 2 | 260 |
| 133 | 1 | 2 | 198 |
| 207 | 1 | 2 | 215 |
| 265 | 1 | 1 | 353 |
| 133 | 2 | 1 | 386 |
| 123 | 2 | 1 | 303 |
| 29 | 2 | 1 | 225 |
| 29 | 2 | 1 | 171 |
| 193 | 2 | 1 | 291 |
| 183 | 2 | 1 | 350 |
| 139 | 2 | 1 | 315 |
| 133 | 1 | 2 | 308 |
| 73 | 1 | 2 | 156 |
| 83 | 1 | 2 | 313 |
| 159 | 1 | 2 | 364 |
| 188 | 1 | 2 | 192 |
| 139 | 1 | 2 | 151 |
| 89 | 1 | 2 | 390 |
| 75 | 1 | 2 | 211 |
| 69 | 1 | 2 | 306 |
| 75 | 1 | 2 | 210 |
| 69 | 1 | 2 | 334 |
| 55 | 1 | 2 | 247 |
| 55 | 1 | 3 | 341 |
| 55 | 1 | 3 | 238 |
| 41 | 1 | 3 | 299 |
| 49 | 1 | 3 | 183 |
| 51 | 1 | 2 | 200 |
| 45 | 1 | 2 | 271 |
| 65 | 1 | 2 | 350 |
| 65 | 1 | 2 | 361 |
| 43 | 1 | 2 | 250 |
| 43 | 2 | 2 | 244 |
| 185 | 2 | 2 | 274 |
| 185 | 2 | 2 | 388 |
| 183 | 2 | 2 | 348 |
| 117 | 2 | 2 | 163 |
| 111 | 1 | 2 | 172 |
| 177 | 1 | 2 | 399 |
| 97 | 2 | 2 | 360 |
| 69 | 2 | 2 | 244 |
| 57 | 2 | 2 | 233 |
| 65 | 2 | 2 | 319 |
| 36 | 2 | 2 | 337 |
| 38 | 1 | 3 | 259 |
| 34 | 1 | 3 | 361 |
| 36 | 1 | 3 | 381 |
| 183 | 2 | 3 | 323 |
| 38 | 2 | 3 | 231 |
| 138 | 2 | 3 | 205 |
| 199 | 2 | 1 | 289 |
| 243 | 2 | 1 | 297 |
| 163 | 2 | 1 | 356 |
| 252 | 2 | 1 | 345 |
| 223 | 2 | 1 | 298 |
| 213 | 2 | 1 | 285 |
| 153 | 2 | 1 | 311 |
| 159 | 2 | 1 | 269 |
| 188 | 2 | 1 | 340 |
| 36 | 2 | 3 | 276 |
| 46 | 2 | 3 | 373 |
| 126 | 2 | 3 | 287 |
| 66 | 2 | 3 | 367 |
| 48 | 2 | 3 | 157 |
| 116 | 1 | 3 | 155 |
| 193 | 1 | 3 | 335 |
| 183 | 1 | 3 | 367 |
| 139 | 1 | 3 | 345 |
| 117 | 2 | 3 | 153 |
| 111 | 2 | 3 | 396 |
| 69 | 2 | 3 | 277 |
| 66 | 2 | 3 | 246 |
| 175 | 2 | 3 | 352 |
| 155 | 2 | 3 | 380 |
| 74 | 2 | 3 | 278 |
| 66 | 2 | 3 | 153 |
| 175 | 2 | 3 | 209 |
In: Statistics and Probability
ANALYSIS An Australian manufacturing company is keen to develop new products and develop new product line of shoes so that the company can expand into Asian markets more than before. The data have been collected for 99 products from the market. The data are in an excel file named “SHOES”. The file includes: PRICE: Price of the shoes in dollars. GENDER: 1 for Female product and 2 for Male product. COUNTRY: the country in which the shoes is produced: 1 made in Thailand, 2 made in Singapore and 3 made in China. COST: Production cost of the shoes in dollars.
questions:
EXCEL Instructions Activation of Data Analysis:
1. Click on File, then click Options.
2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.
Filter numbers: Highlight the column of data/ Data tab/Sort/expand the selection / A/Z Graphs:
1. Highlight all data including labels
2. Insert Tab/ choose the chart. Summary statistics From Menu, Data Tab, Data analysis, Descriptive statistics (highlight data for input range), tick summary statistics and confidence interval, OK Two sample hypothesis testing:
Excel/Data/Data Analysis/ t test, two sample assuming equal variances (or unequal)/ highlight data for variable 1 and 2/ insert the value for Hypothesized difference equal zero and level of significance 0.05.
*if you have highlighted the labels tick (the relevant box. Anova: From Menu, Data Tab, Data analysis, Anova single factor highlight data for input range), insert the value for alpha, OK Regression From Menu, Data Tab, Data analysis, Regression, highlight data for Input Y range and Input X range, tick Residuals Plots boxes, OK
| COST | GENDER | COUNTRY | PRICE |
| 177 | 1 | 1 | 395 |
| 143 | 1 | 1 | 400 |
| 163 | 1 | 1 | 304 |
| 186 | 1 | 1 | 274 |
| 124 | 1 | 1 | 371 |
| 43 | 1 | 1 | 355 |
| 112 | 1 | 1 | 154 |
| 186 | 1 | 1 | 261 |
| 124 | 1 | 1 | 258 |
| 43 | 1 | 1 | 280 |
| 112 | 1 | 1 | 240 |
| 186 | 1 | 1 | 314 |
| 124 | 1 | 1 | 273 |
| 112 | 1 | 1 | 366 |
| 265 | 1 | 1 | 372 |
| 185 | 1 | 1 | 353 |
| 223 | 2 | 1 | 314 |
| 213 | 2 | 1 | 294 |
| 183 | 1 | 1 | 222 |
| 173 | 1 | 2 | 182 |
| 143 | 1 | 2 | 161 |
| 143 | 1 | 2 | 193 |
| 163 | 1 | 2 | 260 |
| 133 | 1 | 2 | 198 |
| 207 | 1 | 2 | 215 |
| 265 | 1 | 1 | 353 |
| 133 | 2 | 1 | 386 |
| 123 | 2 | 1 | 303 |
| 29 | 2 | 1 | 225 |
| 29 | 2 | 1 | 171 |
| 193 | 2 | 1 | 291 |
| 183 | 2 | 1 | 350 |
| 139 | 2 | 1 | 315 |
| 133 | 1 | 2 | 308 |
| 73 | 1 | 2 | 156 |
| 83 | 1 | 2 | 313 |
| 159 | 1 | 2 | 364 |
| 188 | 1 | 2 | 192 |
| 139 | 1 | 2 | 151 |
| 89 | 1 | 2 | 390 |
| 75 | 1 | 2 | 211 |
| 69 | 1 | 2 | 306 |
| 75 | 1 | 2 | 210 |
| 69 | 1 | 2 | 334 |
| 55 | 1 | 2 | 247 |
| 55 | 1 | 3 | 341 |
| 55 | 1 | 3 | 238 |
| 41 | 1 | 3 | 299 |
| 49 | 1 | 3 | 183 |
| 51 | 1 | 2 | 200 |
| 45 | 1 | 2 | 271 |
| 65 | 1 | 2 | 350 |
| 65 | 1 | 2 | 361 |
| 43 | 1 | 2 | 250 |
| 43 | 2 | 2 | 244 |
| 185 | 2 | 2 | 274 |
| 185 | 2 | 2 | 388 |
| 183 | 2 | 2 | 348 |
| 117 | 2 | 2 | 163 |
| 111 | 1 | 2 | 172 |
| 177 | 1 | 2 | 399 |
| 97 | 2 | 2 | 360 |
| 69 | 2 | 2 | 244 |
| 57 | 2 | 2 | 233 |
| 65 | 2 | 2 | 319 |
| 36 | 2 | 2 | 337 |
| 38 | 1 | 3 | 259 |
| 34 | 1 | 3 | 361 |
| 36 | 1 | 3 | 381 |
| 183 | 2 | 3 | 323 |
| 38 | 2 | 3 | 231 |
| 138 | 2 | 3 | 205 |
| 199 | 2 | 1 | 289 |
| 243 | 2 | 1 | 297 |
| 163 | 2 | 1 | 356 |
| 252 | 2 | 1 | 345 |
| 223 | 2 | 1 | 298 |
| 213 | 2 | 1 | 285 |
| 153 | 2 | 1 | 311 |
| 159 | 2 | 1 | 269 |
| 188 | 2 | 1 | 340 |
| 36 | 2 | 3 | 276 |
| 46 | 2 | 3 | 373 |
| 126 | 2 | 3 | 287 |
| 66 | 2 | 3 | 367 |
| 48 | 2 | 3 | 157 |
| 116 | 1 | 3 | 155 |
| 193 | 1 | 3 | 335 |
| 183 | 1 | 3 | 367 |
| 139 | 1 | 3 | 345 |
| 117 | 2 | 3 | 153 |
| 111 | 2 | 3 | 396 |
| 69 | 2 | 3 | 277 |
| 66 | 2 | 3 | 246 |
| 175 | 2 | 3 | 352 |
| 155 | 2 | 3 | 380 |
| 74 | 2 | 3 | 278 |
| 66 | 2 | 3 | 153 |
| 175 | 2 | 3 | 209 |
In: Statistics and Probability
1. Zeebo company is considering investing $425,000 for new equipment. The new equipment is much more efficient than the current machine Zeebo is using. The machine will save $105,000/year in labor and other costs but will require annual maintenance costs of $13,000/year. The machine is expected to last 6 years and will have no salvage value. Estimate the project's Internal Rate of Return and Payback Period.
In: Accounting
You live right on the border between Massachusetts and New Hampshire. In New Hampshire, wine costs $10 per bottle. In Massachusetts, wine also costs $10 per bottle, but Massachusetts adds a tax of $5 per bottle. No matter where you buy wine from, you like 5 parts food for every 1 part wine, implying that your utility function is U=min(F,5W). Food costs $1 per unit in both New Hampshire and Massachusetts and is not taxed in either state. You have $90 per week to spend on food and wine.
(a) What's the equation for the budget constraint in New Hampshire
(b) If you buy all of your wine in New Hampshire, how much wine and food will you buy
(c) Make a graph showing your budget constraint, utility maximizing bundle, and your utility maximizing indifference curve
(d) What is the equation for the budget constraint in Massachusetts
(e) At first, you buy all of your wine in Massachusetts until you find in store you like in NH. Then you buy all of your wine in NH because it's cheaper. Given your utility function, will this price change generate both an income and a substitution effect? Explain
(f) Eventually, you decide to buy some of your wine in Massachusetts and some in NH. The wine store in Massachusetts is closer to your home than the store in NH so you usually buy your first 2 bottles of wine in Massachusetts but drive to NH for any bottle of wine after the first. Graph this budget constraint for food and wine.
In: Economics
In: Statistics and Probability
You are assisting a new patient, Jeffrey, age 23, with completing the new patient assessment form. He is not very talkative and you have a hunch that he is not going to openly share his personal information with you. You know that honest answers are necessary to provide him the best care possible.
In: Nursing