Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you show me how to solve this problem in excel? Thank you. You have an opportunity to acquire a property from First Capital Bank.
can you show me how to solve this problem in excel? Thank you.
You 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 $284,000. If you buy the property, you believe that you will have to spend (1) $11,900 on various acquisition-related expenses and (2) an average of $3,400 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 $264,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 $334,000 at the end of one year. Furthermore, you will probably have to pay about $4,400 in fees and selling expenses in order to sell the property at that time. Required: a. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a good investment? b. What would you need to sell the property for in order to achieve the 20 percent return? (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.) A Answer is complete butinot entirely correct. \begin{tabular}{l|r|r} 11 & PV & 31,900 \\ 12 & PMT & 3,400 \\ 13 & n & 12 \\ 14 & i & 1.67% \\ 15 & FV & $83,654.36 \end{tabular} Sale Price =FV+ selling expenses + Loan Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started