Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook On Second Lien Loans & Intercreditor Agreements

Authors: Mark N. Berman, Jo Ann J. Brighton

1st Edition

0981865593, 978-0981865591

More Books

Students also viewed these Finance questions

Question

12. What does a NOS do? What are the major software parts of a NOS?

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago