Question: CALCULATIONS (50 POINTS) On another sheet, complete the pro forma using your personal expectations given the following inputs. Also please describe what you think is

CALCULATIONS (50 POINTS) On another sheet, complete the pro forma using

CALCULATIONS (50 POINTS) On another sheet, complete the pro forma using your personal expectations given the following inputs. Also please describe what you think is occurring here based on the information you've been provided. Explain all your assumptions. Rate Assumptions: Base Rent Year Over Year Growth Vacancy Rate % Credit Loss % Gross Income Expense Year Over Year Growth Management Fee % Reimbursables Leasing Commissions Year 1 0.00% 2.00% 15.00% 0.00% Year 2 2.00% 2.00% 15.00% 0.00% Year 3 8.00% 20.00% 2.00% 5.00% Year 4 5.00% 2.00% 5.00% 4.00% Year 5 0.67% 3.00% 4.00% 4.00% 0.00% 0.00% 5.00% 2.00% 2.00% Gross Square Footage Elevators Elevator Lobbies Cell Antenna Partnership Lease rents Capitalization Ratio California Property Tax 1,000,000 15% 10% $4000 / mo. $2.00 / sq. ft. 7.00%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Year 5 CALCULATIONS (50 POINTS) On the second page, please complete the pro forma using your personal expectations given the following inputs. Also please describe what you think is occurring here...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

Need some help to check my solutions before submission! ACCT220 - Financial Analysis Portfolio Project Directions & Rubric This Assessment is worth 20% of your overall grade Students will be able to...

please can you explain the Palamon Case, Palamon Caputal Partners/Teamsystem S.P.A PALAMON CAPITAL PARTNERS/TEAMSYSTEM S.P.A. We want to make money by investing in change. -Louis Elson, Managing...

Write a report for MYOB Group Limited, it should including: Budgets and Performance Measures 1. Look for your company's mission statement or statement that sets out the overall philosophy and...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

Please follow the materials under Project and build a master budget on an Excel spreadsheet for requirement 1. Modify the master budget in another sheet for requirement 2. Prepare a 1-page report for...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

pleas I need some help with this case study Henri Boulangerie: Creating and Using a Master Budget BACKGROUND PART I: CREATING THE BUDGET MEETINGS WITH DIVISIONAL MANAGERS Henri Boulangerie is a...

Suppose that Lil John Industries equity is currently selling for $27 per share and that there are 2 million shares outstanding. The firm also has 50 thousand bonds outstanding, which are selling at...

5. Based on the quasichemical model and the phase diagram shown in Fig. 2, (1) Draw the free energy curves of all phases (the phases are for you to identify) for T = 90, 65, and 20 C. (2) Is AHmix...

You have a choice of receiving a wage of $28,000 per year, $2960 per month, $630 per week, or $13.30 per hour. Which pay choice would you take? Assume a 40-hour work week and 52 weeks of work per year

How can delivery companies differentiate themselves from competitors? expand in new, undeveloped markets form a strategic alliance with firms that offer product substitutes decrease delivery time...

This was a conflict between professional and creative people (the WGA) and TV and movie producers. Do you think the conflict was therefore different in any way than are the conflicts between, say,...

MyManagementLab onlycomprehensive writing assignment for this chapter.

Do you agree that employees who excel in nonunion environments earn more than they would in unionized companies? Why?