A restaurant prepares 200.00 pizza slices and sells them at a rate of $15.00/slice. Expenses for the restaurant include raw material for pizza at $6.00 per slice, $124.00 for monthly rental and monthly insurance of $20.00. Lost sale are taken as $5.00 per unhappy customer. Leftover pizza can be sold for $2.00. The restaurant is open only for 25 days in a month. Today there was a party at nearby office so the demand for pizza went up to 224.00 slices. How much profit could the restaurant earn today?
In: Finance
Case Study: Rent vs Own
You are considering an option to purchase or rent a single residential property. You can rent it for $4,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes.
Alternatively, you can purchase this property for $300,000 and finance it with an 80% mortgage at 7% interest, 25 year - fixed. The loan can be prepaid at any time with no penalty.
You have done research in the market and found that properties have historically appreciated at an annual rate of 4% per year. Rents on similar properties have also increased at the same rate. Maintenance and insurance are currently $2,500 each per year and they have been increasing at a rate of 4% per year. Property taxes have generally been about 3% of the property value each year.
If you purchase, the plan is to occupy the property for at least four years. Selling costs would be 7% in the year of sale.
Based on this information you must decide:
In: Finance
A Restaurant is open only for 25 days in a month.
Expenses for the restaurant include raw material for each
sandwich at $6.00 per slice, $1,004.00 as monthly rental and
$470.00 monthly as insurance. They consider the cost of lost sales
as $5.00 per item. They are able to sell any leftover sandwiches
for $3. They prepares 200.00 sandwiches and sells them at a rate of
$12.00/sandwich.
Today there was a party at nearby office so the demand for
sandwiches rose to 226.00. How much profit did the restaurant earn
today?
In: Finance
Using the Vehicle Ratings Excel file, create formulas using nested IF, AND, and OR functions to implement the three rating schemes described on the spreadsheet.
Rating 1 | ||||||||||||||||
If the vehicle has A/C and a sunroof or it is newer than 2013, then YES, otherwise NO. | ||||||||||||||||
Rating 2 | ||||||||||||||||
If the vehicle is Red and does not have high miles, then YES, otherwise if it is a Ford or Chevy, MAYBE, otherwise NO. | ||||||||||||||||
Rating 3 | ||||||||||||||||
If the vehicle is older than 2013 and is priced under $15,000 or it is a Honda with a sunroof, then YES, otherwise, if the vehicle is a black Accord or black Corolla, then MAYBE, otherwise NO. |
Make | Model | Year | Color | A/C | Sunroof | Mileage | High Miles | Price | Rating 1 | Rating 2 | Rating 3 |
Toyota | Corolla | 2009 | Silver | No | Yes | 73,497 | No | $10,497 | |||
Chevrolet | Malibu | 2012 | Blue | No | Yes | 84,690 | No | $11,489 | |||
Ford | Fusion | 2014 | Black | Yes | No | 109,308 | Yes | $11,815 | |||
Honda | Accord | 2013 | Red | No | No | 85,353 | No | $12,493 | |||
Ford | Focus | 2014 | Black | Yes | No | 103,742 | Yes | $12,507 | |||
Toyota | Corolla | 2014 | Black | No | Yes | 109,295 | Yes | $12,593 | |||
Honda | Civic | 2012 | White | Yes | Yes | 119,522 | Yes | $13,333 | |||
Chevrolet | Impala | 2013 | Blue | Yes | No | 108,226 | Yes | $13,630 | |||
Chevrolet | Impala | 2009 | Blue | Yes | Yes | 111,691 | Yes | $13,980 | |||
Ford | Focus | 2012 | Black | No | Yes | 75,772 | No | $14,251 | |||
Honda | Accord | 2012 | Silver | Yes | No | 75,220 | No | $14,258 | |||
Chevrolet | Malibu | 2012 | Blue | No | No | 81,587 | No | $15,246 | |||
Ford | Fusion | 2010 | Red | No | Yes | 79,049 | No | $15,790 | |||
Honda | Civic | 2009 | Blue | Yes | No | 88,548 | No | $16,036 | |||
Toyota | Camry | 2013 | Silver | Yes | Yes | 115,050 | Yes | $16,344 | |||
Honda | Accord | 2013 | Silver | No | No | 77,072 | No | $16,355 | |||
Chevrolet | Malibu | 2011 | Blue | No | Yes | 82,792 | No | $16,556 | |||
Toyota | Camry | 2010 | Red | Yes | Yes | 88,163 | No | $17,248 | |||
Chevrolet | Silverado | 2009 | White | No | No | 100,179 | Yes | $17,964 | |||
Toyota | Corolla | 2013 | Blue | Yes | Yes | 117,039 | Yes | $17,965 | |||
Honda | Civic | 2012 | Red | Yes | No | 73,533 | No | $19,722 | |||
Honda | Civic | 2011 | White | Yes | No | 88,786 | No | $19,864 | |||
Chevrolet | Impala | 2011 | Silver | Yes | Yes | 77,060 | No | $20,339 | |||
Ford | F-150 | 2014 | Red | Yes | No | 105,489 | Yes | $20,380 | |||
Ford | Fusion | 2013 | Silver | No | No | 109,223 | Yes | $20,532 | |||
Ford | F-150 | 2012 | Red | No | No | 76,025 | No | $20,659 | |||
Honda | Accord | 2010 | Blue | Yes | No | 76,701 | No | $21,138 | |||
Chevrolet | Silverado | 2014 | Silver | Yes | No | 72,319 | No | $21,148 | |||
Chevrolet | Malibu | 2013 | White | No | No | 117,518 | Yes | $21,183 | |||
Chevrolet | Silverado | 2009 | Black | No | Yes | 101,839 | Yes | $21,226 | |||
Chevrolet | Malibu | 2014 | Blue | Yes | No | 80,179 | No | $21,466 | |||
Toyota | Camry | 2010 | Blue | No | Yes | 74,937 | No | $21,976 | |||
Ford | F-150 | 2011 | Black | Yes | Yes | 117,249 | Yes | $22,883 | |||
Ford | Focus | 2014 | Silver | Yes | No | 77,527 | No | $23,235 | |||
Ford | Fusion | 2011 | White | Yes | Yes | 81,907 | No | $23,835 |
In: Finance
you have the choice of two investments of equal risk. The required return for both is 8%. The first pays 1500 per month for 30 years and starts in 2 years. The second pays 15000 per year in perpetuity, but starts in 3 years. If the cost of both the investments is the same, which one would you prefer and why?
In: Finance
Bond X is noncallable and has 20 years to maturity, a 7% annual coupon, and a $1,000 par value. Your required return on Bond X is 10%; and if you buy it, you plan to hold it for 5 years. You (and the market) have expectations that in 5, years the yield to maturity on a 15-year bond with similar risk will be 7%. How much should you be willing to pay for Bond X today? (Hint: You will need to know how much the bond will be worth at the end of 5 years.) Round your answer to the nearest cent.
In: Finance
Woodbridge Manufacturing is also considering developing a new assembly line on which to build another new product (not covered in the text). In what category should the costs listed below be placed:
Initial investment outlay (time0)
Supplemental annual cash flows (time1 through timeN)
Terminal value (timeN), or Disregarded?
Also state your reasoning for choosing that classification.
Consider each element individually.
This product has been developed over the past three years, at a
total cost of $125,000.
The building that Woodbridge is planning to be used is currently
rented out to another company for $10,000 per month, and they are
on a month-to-month lease so the lease can be terminated with 90
days' notice.
The new product will replace a current product, which is currently
generating $12,000 per month in free cash flow (cash earnings less
applicable costs).
The machines will cost $750,000.
Travel to see similar machines in operation at another company's
factory costed $3,500.
Freight and installation for the machines will cost $75,000.
It is projected that the additional inventories valued at $80,000
will be required to support sales of the product.
Woodbridge will offer 90 day credit terms to purchasers of the new
product which are expected to expand accounts receivable by an
average of $145,000.
The gross profit (or gross margin) on the sales of the product is
expected to be $360,000 per year for the five years of the
project.
Purchases of material for the project is expected to increase the
balance of the accounts payable by $32,000 during the project
life.
Interest on a loan taken out around the time of starting the
project will be $12,000 per year.
The salvage value of the machines is expected to be $236,000 at the
end of the project.
In: Finance
A project has an initial cost of $52,125, expected net cash inflows of $12,000 per year for 7 years, and a cost of capital of 12%. What is the project's discounted payback period? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places.
In: Finance
Gregory is an analyst at a wealth management firm. One of his clients holds a $10,000 portfolio that consists of four stocks. The investment allocation in the portfolio along with the contribution of risk from each stock is given in the following table:
Stock |
Investment Allocation |
Beta |
Standard Deviation |
---|---|---|---|
Atteric Inc. (AI) | 35% | 0.600 | 38.00% |
Arthur Trust Inc.(AT) | 20% | 1.500 | 42.00% |
Li Corp. (LC) | 15% | 1.100 | 45.00% |
Transfer Fuels Co. (TF) | 30% | 0.500 | 49.00% |
Gregory calculated the portfolio’s beta as 0.825 and the portfolio’s expected return as 12.19%.
Gregory thinks it will be a good idea to reallocate the funds in his client’s portfolio. He recommends replacing Atteric Inc.’s shares with the same amount in additional shares of Transfer Fuels Co. The risk-free rate is 6%, and the market risk premium is 7.50%.
According to Gregory’s recommendation, assuming that the market is in equilibrium, how much will the portfolio’s required return change?
0.26 percentage points
0.20 percentage points
0.32 percentage points
0.30 percentage points
Analysts’ estimates on expected returns from equity investments are based on several factors. These estimations also often include subjective and judgmental factors, because different analysts interpret data in different ways.
Suppose, based on the earnings consensus of stock analysts, Gregory expects a return of 13.43% from the portfolio with the new weights. Does he think that the revised portfolio, based on the changes he recommended, is undervalued, overvalued, or fairly valued?
Undervalued
Fairly valued
Overvalued
Suppose instead of replacing Atteric Inc.’s stock with Transfer Fuels Co.’s stock, Gregory considers replacing Atteric Inc.’s stock with the equal dollar allocation to shares of Company X’s stock that has a higher beta than Atteric Inc. If everything else remains constant, the portfolio’s beta would .
In: Finance
Sukhum, Inc. Balance Sheet as of December 31, for 2001 and 2002 | |||||||
Assets | 2001 | 2002 | Liabilities and equity | 2001 | 2002 | ||
Current liabilities | |||||||
Accounts payable | $210 | $210 | |||||
Current assets | Notes payable | 110 | 110 | ||||
Cash | $45 | $45 | Total | $320 | $320 | ||
Accounts receivable | 260 | 260 | Long-term debt | 205 | 205 | ||
Inventory | 320 | 340 | Stockholders’ equity | ||||
Total | $625 | $645 | Common stock | 290 | ??? | ||
Retained earnings | 795 | ??? | |||||
Fixed assets | 985 | 1090 | Total Equity | $1,085 | ??? | ||
Total assets | $1,610 | $1,735 | Total liabilities and eq | $1,610 | ??? | ||
9 | Replace the "???" in the balance sheet for 2002 with appropriate numbers and determine what | |||||
was the cash flow to stockholders of Sukhum Inc for 2002? | ||||||
A) | -$45 | |||||
B) | -$40 | |||||
C) | -$5 | |||||
D) | $5 | |||||
E) | $40 |
Sukhum, Inc., Income Statement (2002) | ||
Net sales | 710 | |
Cost of goods sold | 460 | |
Depreciation | 50 | |
Earnings before interest | ||
and taxes (EBIT) | $200.00 | |
Interest | 20 | |
Taxable income | 180 | |
Taxes | 60 | |
Net income | $120.00 | |
Dividends | 40 | |
Addition to retained earnings | $80.00 |
this is all the information that is given to me.
.
In: Finance
A project has an initial cost of $50,000, expected net cash inflows of $11,000 per year for 9 years, and a cost of capital of 11%. What is the project's IRR? Round your answer to two decimal places.
In: Finance
Suppose you wish to plan for your newborn’s college tuition payment. You intend to make equal quarterly deposits into an account offering annual rate of 6% compounded quarterly on the child’s 1st through 12th birthdays. You expect that tuition payments will be $40,000 every six months by the time the child is ready to enter college. Therefore, your goal is to make eight semi-annual withdrawals of $40,000 each starting on the child’s 18th birthday to be used for his tuition payments. How much must each of the quarterly deposits be such that there will be enough money accumulated in the account to exactly meet the goal? Assume the account offers 6% per year compounded quarterly until the child’s 18th birthday and 6% per year compounded semi- annually after that. [Suggestion: Draw the cash flow diagram to aid you in solving this problem.
In: Finance
In Australia, the Federal and State governments can raise funds by issuing bonds. Please list the major investors names of these fond .
In: Finance
Q 10
St. Johns River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings before depreciation from $27,000 to $52,000 per year. The new machine will cost $82,500, and it will have an estimated life of 8 years and no salvage value. The new machine will be depreciated over its 5-year MACRS recovery period; so the applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. The applicable corporate tax rate is 40%, and the firm's WACC is 10%. The old machine has been fully depreciated and has no salvage value.
What is the NPV of the project? Negative value, if any, should
be indicated by a minus sign. Round your answer to the nearest
cent.
$
Should the old riveting machine be replaced by the new
one?
-Select-YesNoItem 2
In: Finance
St. Johns River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings before depreciation from $27,000 to $52,000 per year. The new machine will cost $82,500, and it will have an estimated life of 8 years and no salvage value. The new machine will be depreciated over its 5-year MACRS recovery period; so the applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. The applicable corporate tax rate is 40%, and the firm's WACC is 10%. The old machine has been fully depreciated and has no salvage value. What is the NPV of the project? Negative value, if any, should
be indicated by a minus sign. Round your answer to the nearest
cent. Should the old riveting machine be replaced by the new
one? |
please show clear expiation i want to do it by my self again and get the same result
In: Finance