By using excel, you are given the following data to calculate the Internal Rate of Return (IRR) of a 5-year store investment: - Annual income €455,000 - Purchase Rent: €585,000 - Rent Review every three years - Rent Review Cost: 4% - Vacancy Losses: 4% - Operating Expenses: 8% - Rent Growth Rate: 2.5% - Acquisition Costs: 3% - Selling Costs: 3% - Entry Cap Rate: 6% - Exit Cap Rate: 6.5% Is it a good investment if the Required Return is 10%?

By using excel, you are given the following data to calculate the Internal Rate of Return (IRR) of a 5-year store investment: - Annual income €455,000 - Purchase Rent: €585,000 - Rent Review every three years - Rent Review Cost: 4% - Vacancy Losses: 4% - Operating Expenses: 8% - Rent Growth Rate: 2.5% - Acquisition Costs: 3% - Selling Costs: 3% - Entry Cap Rate: 6% - Exit Cap Rate: 6.5% Is it a good investment if the Required Return is 10%?

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter12: Corporate Valuation And Financial Planning

Section: Chapter Questions

Problem 2STP

See similar textbooks

Similar questions

A company is thinking of investing in one of two potential new products for sale. The projections are as follows: Year Revenue/cost £ (Product A) Revenue/cost £ (Product B)0 (150,000) outlay (150,000) outlay 1 24,000 12,0002 24,000 25,3333 44,000 52,0004 84,000 63,333 1.Calculate the payback period for both products in years and months, not as a decimal. Please present answer to nearest half a month.
Cullumber Specialties just purchased inventory-management computer software at a cost of $1,440,950. Cost savings from the investment over the next six years will produce the following cash flow stream: $128,340, $258,240, $432,600, $435,250, $794,320, and $649,740. What is the payback period on this investment? - Payback period is years?
choose the letter of the correct answer Log Company’s credit sales are P300,000, and the collection period is 90 days. Cost is 70 percent of selling price. Determine Log's average investment in accounts receivable. a. P32,500.00b. P42,500.00c. P52,500.00d. P62,500.00e. P72,500.00
A company is thinking of investing in one of two potential new products for sale. The projections are as follows: Year Revenue/cost £ (Product A) Revenue/cost £ (Product B)0 (150,000) outlay (150,000) outlay 1 24,000 12,0002 24,000 25,3333 44,000 52,0004 84,000 63,333 a) Calculate decimal. Please present answer to nearest half a month.
A. DEF has total forecasted gross purchases of P4,500,000 relating to a major supplier for the coming year. The supplier is offering a credit term of 3/15, n/45. How much is the simple annual effective cost of paying on the 45th day? B. ABC can take a 45-day loan with a 15% interest deducted in advance, to be reapplied each time. How much is the simple annual cost of the loan? C. ABC’s bank offered a loan with conditions of a P5,000,000 face amount, 6-month term, 4% interest deducted in advance and bank charge of P30,000. How much is the compounded annual effective cost of the bank loan?
Question for Maroon Company: • HOW MUCH IS THE GAIN OR LOSS IF THE BLDG IS SOLD FOR P8MILLION ONE YEAR AFTER REVALUATION? • HOW MUCH IS THE BLANCE OF REVALUATION SURPLUS AFTER THE SALE? For Noypi Store, follow the requirement. (Choose from the choices and kindly provide a solution.)
Uptown Bank has granted a line of credit of $80,000 with an interest rate of 7.5 percent and a compensating balance requirement of 2.5 percent to Jones Hardware. The compensating balance requirement is based on the total amount borrowed. What is the effective annual interest rate if the firm needs $55,000 for one year to finance its inventory? Group of answer choices
The Lux Co. has an inventory conversion period of 60 days, a receivable conversion period of 35 days, and a payable payment period of 45 days. The Lux Co.’s variable cost ratio is 65% and annual fixed costs of P600,000. The current cost of capital for National Co. is 12%.If Lux Co.’s annual sales are P3,375,000 and all sales are on credit, what is the firm’s carrying cost on accounts receivable, using 360 days year?
Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days.Assume that cost of goods sold is 80% of sales.a. What is the length of the firm’s cash conversion cycle?b. If annual sales are $4,380,000 and all sales are on credit, what is thefirm’s investment in accounts receivable?c. How many times per year does Negus Enterprises turn over its inventory?
You own a company. This company’s projected revenue is $30,000 for year 1, $31,000 for year 2, and $32,000 for year 3. From the 4th year onwards, revenue is expected to be 5% higher than the previous year. Assume the appropriate nominal discount rate is 8%, and all revenue is collected at the end of each year. Determine the present value of your sales revenue for the first 15 years, round to 2 decimal places. [show the step by step of how to find each result]
You are asked to complete a financial projection for a hardware company using straight line method complete the form and compute the yearly projected sales and revenue using the following assumptions Here are some assumptions to consider: -income the company is projecting cells to increase 8% each year -interest income remain at 1200 every year
The cost of product X is 30 percent of its selling price, and the carrying cost is 8 percent of selling price. Accounts are paid on average 60 days after sale. Sales per month average P25,000. What is the investment in accounts receivable? choose the letter of the correct answera. P8,000.00b. P9,000.00c. P19,000.00d. P29,000.00e. P39,000.00