Homework_1
.docx
keyboard_arrow_up
School
Georgia Institute Of Technology *
*We aren’t endorsed by this school
Course
6611
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
8
Uploaded by CountGrouseMaster920
CRP 6611 Real Estate Finance and Development
Professor Raymond
Homework Number 1
Please use the text of the questions below, which may differ slightly from your textbook depending on which edition you purchased. All homework assignments are to be turned in via hard copy. They should be typed and numerical problems should be done in Excel. Please note the rules for downgrading of late assignments in the syllabus. Show your work. For Excel work (problems #5+), you should clearly indicate which function you used and what values you used for the input parameters (e.g., NPER, RATE, etc.) in the function. For example, if you use the Future
Value (FV) function, indicate the values used for RATE, NPER, PMT, and PV. Each function has a different set of input parameters. For these problems, so that I can be sure you are following, you should show your work by indicating function and input values used. Merely cutting and pasting the function directly from Excel is often less than clear. (Cutting and pasting the input window is more clear, but can take up more space.)
Most importantly, be clear in your presentation and do not scatter work in various places. That is, do not answer a question narratively and then refer to excel tables or other material that is attached in some appendix or somewhere else. Integrate any tables, formula, etc. so that they are located close to any narrative comments. Answers are due at
the BEGINNING of class uploaded to Canvas. MAKE SURE THAT IT IS ALL IN ONE DOCUMENT/FILE. It should
all be integrated in one Word or pdf file that is easily readable and prints without any manipulation on my part.
Finally, do not
use web-based financial calculator tools.
1.
The NDC real estate finance text argues that development finance tools can make “any project viable.” Do you agree? Why or why not? (4-5 sentences maximum)
I believe that the availability of development finance tools increases the potential viability of any project. However, this potential relies on people's access to education, enabling them to utilize these tools effectively. I think it is also important to acknowledge that other factors, such as regulatory hurdles, environmental concerns, or community opposition, can influence a project's viability and are not necessarily addressed by financial tools.
2.
Distinguish – in a few sentences – each of the following pairs of terms:
a.
Junior vs. senior mortgage
There are often multiple loans on a real estate deal. A senior mortgage is also known as the first mortgage and is the one that takes priority/ is paid first. A junior mortgage is an additional home loan that is made whilst the senior mortgage is still in effect. In the event of default, the senior mortgage would receive all the proceeds from the liquidation of the property until it is paid off. b.
Seller financing vs. land contract
Seller financing involves the buyer obtaining a mortgage from the seller rather than from a traditional financial institution. The seller takes back a mortgage as part or full payment of the purchase price. The buyer and the seller agree to home loan terms, and the buyer makes payments to the seller. The buyer immediately receives the legal title to the property. A land contract is a legal agreement where the owner finances the buyer’s purchase of a piece of real estate. The seller retains the legal title to the property until the buyer completes all the payments agreed upon. c.
Note vs. mortgage
A note is a borrower’s written, signed promise that they are going to repay the loan. This note creates a loan obligation and is a contract separate from the mortgage. This note lets a lender go after the borrower for the money owned. A mortgage is a contract you sign with the lender to provide collateral for a loan. By signing a mortgage, you put the property up as collateral for the loan and give the lender the right to sell the property through foreclosure and use the proceeds from the sale to make up what is owed on the mortgage. A mortgage lets a lend seize a property in repayment for the money borrowed.
3.
B&F, Chapter 2, Problems
(NOT “Questions”) #1 and #2. Be brief. #1. Sedgewick arranged for an open-end construction loan from the Second National Bank not to exceed $50,000. The loan was closed and Sedgewick drew $30,000 initially. Three months later, he drew the remaining $20,000. What is the bank’s position concerning the possibility of intervening liens? Sedgewick arranged an open-end construction loan, meaning he had already arranged in advance the total amount of the loan- $50,000. The open-end loan has been agreed upon by the bank and Sedgewick and will be advanced, in stages, to meet the costs of the construction. Sedgewick has the right to call upon another bank for successive advances on the loan and all improvements become security under the terms of the mortgage as they are constructed. Therefore, because the loan is open-ended the bank would
be agreeable to intervening liens as they are still the priority lien. #2. If, in problem 1, there was no definite agreement for future advances between Sedgewick and the bank at the time the initial $30,000 loan was closed, would your answer be different? If there was no definite agreement for future advances between Sedgewick and the bank, then the bank may have an issue with Sedgewick attempting to obtain further liens. The bank is not protected
against intervening liens and is only protected up to the original amount of $30,000. 4.
B&F, Chapter 2, Problems #5 and #7
#5. Mort owns a property. Jessica Rosen holds a first mortgage and Alex Nelligan holds a second mortgage. Mort defaults on his mortgage payments. Ms. Rosen forecloses without joining Mr. Nelligan in the foreclosure suit. The property is sold to Sheila McBride at the foreclosure sale. What are Mr. Nelligan’s rights? Rosen forecloses without joining Nelligan in a foreclosure sale. Every foreclosure action should be preceded by a careful search of the records to discover any junior lien claimants who should be joined in
the foreclosure suit. Nelligan was not joined in the suit and therefore he could acquire the position of a senior lienor and still go ahead with a foreclosure as he had a secure interest in the property. #7. In Problem #5, what if Mr. Nelligan was joined in the foreclosure suit but forgot to attend the sale and bid. Does Mr. Nelligan have any other way of getting Mort to pay? Nelligan did not attend the foreclosure sale and lost his opportunity to bid on the property. However, Nelligan may be able to make a claim and maintain his rights to pursue the mortgagors on whatever personal obligation they have incurred by obtaining the mortgage. This might not be worth it in the long run though. 5.
B&F, Chapter 3, Problem #1
#1 Jim makes a deposit of $12,000 in a bank account. The deposit is to earn interest compounded annually at the rate of 9 percent for seven years.
a.
How much will Jim have on deposit at the end of seven years? (Hint: what is the future value?)
b.
Assuming the deposit earned a 9 percent rate of interest compounded quarterly, how much would he have at the end of seven years? c.
In comparing (a) and (b), what are the respective effective annual yields? (Hint: Consider the future value of each deposit after one year only.) Which alternative is better? B is the better option as the interest compounds more frequently meaning you gain more interest. The future value for A is $21,936.47 as compared to $22,374.54 when the interest is compounded quarterly. Effective annual yield. Abs. value (FV)-Abs value (PV)/ PV= 9.31%
6.
B&F, Chapter 3, Problem #6 #6. Suppose you have the opportunity to make an investment in a real estate venture that expects
to pay investors $750 at the end of each month for the next eight years. You believe that a reasonable return on your investment should be an annual rate of 17 percent compounded monthly
. a.
How much should you pay for this investment.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Could i have this answer in formula version?
arrow_forward
Urgent pls answer the question attached below.This is how you answer the problem:-Identify the given -What is being ask in the problem-Provide the formula(pls include this because this is my basis on what topic the problem all about)-Solution(plug in the given to the formula and show me the flow of the computation)That's all. Thanks in advance :)
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
4
arrow_forward
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/
3- Homework
Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indi
Required information
[The following information applies to the questions displayed below.]
Determine the amount of the late filing and late payment penalties that apply for the following taxpayers.
As
b. Oscar filed his tax return and paid his $4,400 tax liability seven months late.
Saved
Answer is complete but not entirely correct.
Late filing and late payment penalties $ 1,100 x
arrow_forward
Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).
arrow_forward
I didn’t realize i had to specify being taught by formula. A computerized version doesn’t help me. Will all my questions be answered like this if I didn’t specify?
Also please answer this question in formula long hand.
Also, is there any way to request a specific tutor?
arrow_forward
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
whats the answer for number 2
arrow_forward
Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?
arrow_forward
Hey I was wondering if I can get help with this thank you
arrow_forward
Examity Dashboard (click this
Question 2 - Chapter 12 Home x
O ezto.mheducation.com/ext/map/index.html?.con=con&external browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%25
Chapter 12 Homework a
Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate comp
Zachary Services Company has 61 employees, 36 of whom are assigned to Division A and 25 to Division B. Zachary incurred $364,170
of fringe benefits cost during year 2.
20
points
Required
Determine the amount of the fringe benefits cost to be allocated to Division A and to Division B.
O Answer is complete but not entirely correct.
Allocated
Cost
Division
A
s 160,420 O
B
$ 172,760
MacBook Air
arrow_forward
CAN YOU HELP ME SOLVE THIS QUESTION
arrow_forward
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
arrow_forward
Give reflection of this homework.
arrow_forward
A CSUF Portal
E MyLab and Mastering
P Do Homework - Chapter 8 Hon x
->
->
a mathxl.com/Student/PlayerHomework.aspx?homeworkld=606850034&questionld=1&flushed%3false&cld%3D6647439&back=https://www.mathxl.com/Student/DOAS..
Update
Financial Management I
Shaheen Behbehani a
10/25/21 8:33 PM
Question 2, P 8-8 (similar...
HW Score: 0%, 0 of 10 points
E Homework: Chapter 8 Homework
O Points: 0 of 1
Save
Part 1 of 3
Your factory has been offered a contract to produce a part for a new printer. The contract would last for 3 years and your cash flows from the contract would be $4.93 million per year. Your upfront setup costs to be ready to produce the part would
be $7.91 million. Your discount rate for this contract is 7.6%.
a. What does the NPV rule say you should do?
b. If you take the contract, what will be the change in the value of your firm?
a. What does the NPV rule say you should do?
The NPV of the project is $ million. (Round to two decimal places.)
Clear All
Check Answer
Help Me Solve…
arrow_forward
Comprehensive Problem 1Part 5: Work Sheet
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts 1, 2, 3, 4 before completing part 5.
Part 5: Enter the unadjusted trial balance on an end-of-period spreadsheet (work sheet) and complete the spreadsheet using the following adjustment data.
Insurance expired during May is $275.
Supplies on hand on May 31 are $715.
Depreciation of office equipment for May is $330.
Accrued receptionist salary on May 31 is $325.
Rent expired during May is $1,600.
Unearned fees on May 31 are $3,210.
If an amount box does not require an entry, leave it blank or enter "0".
Kelly ConsultingEnd-of-Period Spreadsheet (Work Sheet)For the Month Ended May 31, 20Y8
Unadjusted Trial Balance
Adjustments
Adjusted Trial Balance
Income Statement
Balance Sheet
Account Title
Debit
Credit
Debit…
arrow_forward
Need help with blank box. I can't solve it and can you show me step by step how you got it.
arrow_forward
8:36
Chegg Home Expert Q&A
Chapter Summary Assignment #3 (Ch 5 & 6) D2L quiz questions will be asked in
class based on your completion of this preparation guide. Example in class question: What is
the debit account in Question 2? You will not have time to complete this guide in class! You
are required to handwrite your answers to this assignment.
My answers
Part 1: Prepare Bluth Co.'s journal entries for each of the following transactions. Assume that
a perpetual inventory method is used.
Recording Purchases of Merchandise
1. Bluth Co. purchases $75,000 of inventory on account, terms 2/10 net
30 from Sitwell Enterprise.
2. Bluth Co. returns $5,000 of inventory to Sitwell Enterprise from the
initial purchase.
3
3. Bluth Co. pays the balance owed to Sitwell Enterprise, taking the
discount.
Recording Sales of Merchandise (new scenario)
4. Bluth Co. sells merchandise on account for $29,000 (terms 3/10 net
30) to Franklin Inc. The merchandise had cost Bluth Co. $15,500.
Show Transcribed…
arrow_forward
Hi I need further clarity on a question that has been answered on your site. Is it possible to show all calculations no matter how minor. With focus on how the balance figure is calculated and how the steps are linked
Thank u in advance
arrow_forward
Required information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B13 enter the formula "= B5".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them.
Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…
arrow_forward
Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".
arrow_forward
Accounting Excel Practice Problem - I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formula figured out.
arrow_forward
Please correct answer and step by step solution
arrow_forward
E Chapter 5 Homework - FINANCIA X
O NWP Assessment Player UI Appli X
b Answered: The accountant of Lati x
M Inbox - dhyani11141999@gmail. X
b My Questions | bartleby
+
i assessment.education.wiley.com/was/ui/v2/assessment-player/index.html?launchld=1d52287e-dfd8-4d2a-80c9-4cbf51a01297#/question/5
E Chapter 5 Homework
Question 6 of 6
>
-/ 1
View Policies
Current Attempt in Progress
The comparative balance sheets of Constantine Cavamanlis Inc. at the beginning and the end of the year 2020 are as follows.
CONSTANTINE CAVAMANLIS INC.
BALANCE SHEETS
Dec. 31, 2020
Jan. 1, 2020
Inc./Dec.
Assets
Cash
$ 45,000
$ 13,000
$32,000
Inc.
Accounts receivable
91,000
88,000
3,000
Inc.
Equipment
39,000
22,000
17,000
Inc.
Less: Accumulated Depreciation-Equipment
17,000
11,000
6,000
Inc.
Total
$158,000
$112,000
Liabilities and Stockholders' Equity,
Accounts payable
$ 20,000
$ 15,000
5,000
Inc.
Common stock
100,000
80,000
20,000
Inc.
Retained earnings
38,000
17,000
21,000
Inc.
Total
$158,000
$112,000
Net…
arrow_forward
Need help with area showcases the red x. I can't solve it and can you show me step by step how you got it.
arrow_forward
E Chapter 5 Homework - FINANCIA X
O NWP Assessment Player UI Appli X
b Answered: The accountant of Lati x
M Inbox - dhyani11141999@gmail. X
b My Questions | bartleby
+
i assessment.education.wiley.com/was/ui/v2/assessment-player/index.html?launchld3D1d52287e-dfd8-4d2a-80c9-4cbf51a01297#/question/0
E Chapter 5 Homework
Question 1 of 6
>
-/ 1
View Policies
Current Attempt in Progress
Koch Corporation's adjusted trial balance contained the following asset accounts at December 31, 2020: Cash $7,000, Land
$40,000, Patents $12,500, Accounts Receivable $90,000, Prepaid Insurance $5,200, Inventory $30,000, Allowance for Doubtful
Accounts $4,000, and Equity Investments (to be sold in the next quarter) $11,000.
Prepare the current assets section of the balance sheet. (List Current Assets in order of liquidity.)
КОСН СORPORATION
Balance Sheet (Partial)
2$
2$
1:37 PM
O Type here to search
9/24/2020
2
..
arrow_forward
E Chapter 5 Homework - FINANCIA X
O NWP Assessment Player UI Appli X
b Answered: The accountant of Lati x
M Inbox - dhyani11141999@gmail. X
b My Questions | bartleby
+
i assessment.education.wiley.com/was/ui/v2/assessment-player/index.html?launchld3D1d52287e-dfd8-4d2a-80c9-4cbf51a01297#/question/4
E Chapter 5 Homework
Question 5 of 6
>
-/ 1
View Policies
Current Attempt in Progress
The major classifications of activities reported in the statement of cash flows are operating, investing, and financing. Classify each of
the transactions listed below as:
1.
Operating activity-add to net income.
2.
Operating activity-deduct from net income.
3.
Investing activity.
4.
Financing activity.
5.
Reported as significant noncash activity
The transactions are as follows.
Transactions
Classifications of Activities
(a)
Issuance of common stock.
(b)
Purchase of land and building.
(c)
Redemption of bonds.
(d)
Sale of equipment.
(e)
Depreciation of machinery.
(f)
Amortization of patent.
1:39 PM
O Type…
arrow_forward
-vera fonda@student.pms..
Course: Intro Fin Acc- Bus 28
WileyPLUS
Exercise 9-5 (Part Level Submission)
Math Problem Solver and Caiculator
Print by: 13111810287 Vera Maria Fonda
50077495-50077495MJNV1W09_C:Intro Fin Acc - Bus 28 / Chapter 9a
*Exercise 9-5 (Part Level Submission)
Windsor Bus Lines uses the units-of-activity method in depreciating its buses. One bus was purchased on January 1, 2017, at a cost of R$245,210. Over its 7-year useful life, the bus is expected to be
driven 170,600 miles. Residual value is expected to be R$14,900.
V Your answer is correct.
Compute the depreciable cost per unit. (Round answer to 2 decimal places, e.g. e.50.)
Depreciation cost per unit
RSL.35
per mile
Attempts: 1 of 2 used
Mari
1181
*(b)
Prepare a depreciation schedule assuming actual mileage was 2017, 42,900; 2018, 49,500; 2019, 42,300; and 2020, 35,900. (Round answers to o decimal places, e.g. 2,125 except Depreciation
Cost /Unit.)
reen Sh
1222
End of Year
Computation
Annual
Accumulated…
arrow_forward
Can someone help who knows how to use Excel?? Thank you.
Mainly need help with the formulas and how to write them.
Help with d. i. and k.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Could i have this answer in formula version?arrow_forwardUrgent pls answer the question attached below.This is how you answer the problem:-Identify the given -What is being ask in the problem-Provide the formula(pls include this because this is my basis on what topic the problem all about)-Solution(plug in the given to the formula and show me the flow of the computation)That's all. Thanks in advance :)arrow_forwardDirections 1 Given cose = 2, and is in Quadrant 1, what is tane? You must show all of your work to receive credit for this problem. Please choose one option to complete this activity. Sketchpad FILE UPLOAD i Question 7 OR 1 File Upload Upload your work. Show all steps to receive credit for this problem.arrow_forward
- 4arrow_forwardezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/ 3- Homework Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indi Required information [The following information applies to the questions displayed below.] Determine the amount of the late filing and late payment penalties that apply for the following taxpayers. As b. Oscar filed his tax return and paid his $4,400 tax liability seven months late. Saved Answer is complete but not entirely correct. Late filing and late payment penalties $ 1,100 xarrow_forwardAccounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).arrow_forward
- I didn’t realize i had to specify being taught by formula. A computerized version doesn’t help me. Will all my questions be answered like this if I didn’t specify? Also please answer this question in formula long hand. Also, is there any way to request a specific tutor?arrow_forward1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…arrow_forwardwhats the answer for number 2arrow_forward
- Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?arrow_forwardHey I was wondering if I can get help with this thank youarrow_forwardExamity Dashboard (click this Question 2 - Chapter 12 Home x O ezto.mheducation.com/ext/map/index.html?.con=con&external browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%25 Chapter 12 Homework a Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate comp Zachary Services Company has 61 employees, 36 of whom are assigned to Division A and 25 to Division B. Zachary incurred $364,170 of fringe benefits cost during year 2. 20 points Required Determine the amount of the fringe benefits cost to be allocated to Division A and to Division B. O Answer is complete but not entirely correct. Allocated Cost Division A s 160,420 O B $ 172,760 MacBook Airarrow_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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning