Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Related questions
Question
You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,330,000; rents are estimated at $170,240 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 6 percent interest for 30 years (total annual payments will be monthly payments × 12). The property is expected to appreciate in value at 2 percent per year and is expected to be owned for five years and then sold.
SAVE
AI-Generated Solution
info
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
to generate a solution
Click the button to generate
a solution
a solution
Knowledge Booster
Similar questions
- You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,290,000; rents are estimated at $165,120 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 7 percent interest for 30 years (total annual payments will be monthly payments × 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What…arrow_forwardYou are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,280,000; rents are estimated at $163,840 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 8 percent interest for 30 years (total annual payments will be monthly payments 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is…arrow_forwardYou are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,400,000; rents are estimated at $179,200 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 8 percent interest for 30 years (total annual payments will be monthly payments 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is…arrow_forward
- You are an employee of University Consultants, Ltd., and have been given the following assignment. You are to present an investment analysis of a new small residential income-producing property for sale to a potential investor. The asking price for the property is $1,250,000; rents are estimated at $200,000 during the first year and are expected to grow at 3percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A 70 percent loan can be obtained at 11 percent interest for 30 years. The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. a. What is the investor’s expected before-tax internal rate of return on equity invested (BTIRR)?b. What is the first-year debt coverage ratio?c. What is the terminal capitalization rate?d. What is the NPV using a 14 percent discount rate? What does this mean?arrow_forwardYou are an employee of University Consultants, Ltd., and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,255,000 rents are estimated at $160, 500 during the first year and are expected to grow at 2.5 percent per year thereafter. The investor tells you she would like to know how tax considerations affect your investment analysis. You determine that the building represents 85 percent of value and would be depreciated over 39 years (use 1/39 per year, except year 1 depreciation is also multiplied by 11.5/12 to adjust for the mid month convention). The potential investor indicates that she is in the 37 percent tax bracket and has enough passive income from other activities so that any passive losses from this activity would not be subject to any passive activity loss limitations. Capital gains from price appreciation will be taxed at 20…arrow_forwardYou have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $218,000. If you buy the property, you believe that you will have to spend (1) $10,800 on various acquisition-related expenses and (2) an average of $2,300 per month during the next 12 months for repair costs, and so on, in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $198,000 in financing at 4.25 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $248,000 at the end of one year. Furthermore, you will probably have to pay about $3,300 in fees and selling expenses in order to sell the property at that time. Required: a. If you wanted to earn a 20 percent returi compounded monthly, do you believe that this…arrow_forward
- Prepare a project charter for the Fixer Upper Project. Assume the project will take six months to complete and cost about $350,000 (or agreed upon price), that you estimate you will spend $40,000 for renovations. The first three months of the project will involve finding and closing on the property, and the last three months will involve fixing up the property, finding renters (preferably two renters), and preparing financial information for you and your aunt. Assume the project starts on October 1 and finishes on April 1. Recall that the main project objectives are to find and renovate a house that your Aunt Julie would own but you would live in and be able to rent out one to three rooms. Julie has also agreed that she will let you earn equity on the house. As she has said to you a few times, "Pretend I'm your banker, and it's your home." You will do all of the renovation planning work, including creating detailed cost estimates for all of the renovations, preparing a detailed…arrow_forwardYou have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition-related expenses and (2) an average of $2,000 per monthduring the next 12 months for repair costs, etc., in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $180,000 in financing at 8 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $225,000 at the end of one year. Furthermore, you will probably have to pay about $3,000 in fees and selling expenses in order to sell the property at that time. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a good…arrow_forwardYou have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition related expenses and (2) an average of $2,000 per month during the next 12 months for repair costs, and so on, in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $180,000 in financing at 4.25 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $225,000 at the end of one year. Furthermore, you will probably have to pay about $3,000 in fees and selling expenses in order to sell the property at that time. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a…arrow_forward
- The Business Manager of a Commercial Laboratory needs to determine the present value of a $170,000 investment received at the end of year 7. What is the present value of the investment if the discount rate is 6%?arrow_forwardLou Lewis, the president of Lewisville Company has asked you to give him an analysis of the best use of a warehouse the company owns. The company has a 40% effective tax rate. a. Lewisville Company is currently leasing the warehouse to another company for $5,000 per month on a year-to-year basis. b. The warehouse's estimated sales value is $200,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $60,000 and is being depreciated at $1,500 annually. Its current net book value (NBV) is $7,500. 1. Show how you would handle the individual items in determining whether the company should continue to lease the space or convert it to a factory outlet. Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (complete questions is attached.) Thank you!!!arrow_forwardYour boss asks you to review an option to lease an equipment storage facility that the firm needs. You are to compare it with the purchase of the facility. The following information are pertinent to your decision: - The facility will be needed for twelve years -If the facility is leased, the lessor will conduct all maintenance; if purchased, your firm must conduct maintenance - Facility maintenance is expected to cost $85000 per year - The cost to lease the facility is $800000 per year at the beginning of each year - The purchase price of the facility is $6000000 and the market value at the end of twelve years is expected to be $3000000 The before-tax cost of debt is 8%, and the tax rate is 30% - The company's current EBIT is $1800000 (before leasing or purchasing the facility). Assuming that the facility has a twelve-year depreciation life for tax purposes (i.e. it can be fully depreciated over twelve-years), compute the NPV for cach option and based on the cost, indicate your…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College