You have been asked to develop a pro forma statement of cash flow for West Office Plaza. The information given to you is listedbelow.Property Information:WEST OFFICE PLAZARentable AreaAgeNumber of Stories:Number of Tenants330,000 square feet8 years1540Financial Information:Base Rent AverageOther Income/Parking/StorageExpenses Recoverable from TenantsCurrent VacancyExpenses:Management/Administration/Security/OwnershipProperty TaxesInsurance.General Operations/Leasing Expense/MarketingUtilitiesJanitorial/CleaningBusiness TaxesOther:Recurring CAPEX/Improvement Allowance$ 20 per square feet$ 3.00 per square feet$ 4.00 per square feet5%$ 698,000$ 682,500$ 433,000$ 674,500$ 1,166,600$ 496,500$ 117,500$ 707,500Required:a. Develop a pro forma statement of cash flow for a base year showing net operating income (NOI) for West Office Plaza.WEST OFFICE PLAZA Required:a. Develop a pro forma statement of cash flow for a base year showing net operating income (NOI) for West Office Plaza.RevenueAdd:Other income (parking)Recoverable expensesLess:VacancyEffective gross incomeLess: Operating expensesBusiness taxesInsuranceOperating/LeasingManagement/AdministrationUtilitiesProperty taxesJanitorial/CleaningWEST OFFICE PLAZATotal operating expensesCap expenses/Improvement allowanceNet operating income0$00

Name: You have been asked to develop a pro forma statement of cash flow for
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: You have been asked to develop a pro forma statement of cash flow for West Office Plaza. The information given to you is listedbelow.Property Information:WEST OFFICE PLAZARentable AreaAgeNumber of Stories:Number of Tenants330,000 square feet8 years1

A pro forma statement of cash flow is the presentation of cash flows on which a movement of cash is…

Answered: Required: a. Develop a pro forma…

Business

Accounting

Required: a. Develop a pro forma statement of cash flow for a base year showing net operating income (NOI) for West Office Plaza.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 14M

See similar textbooks

Similar questions

Common-size Balance Sheet. Explain what it is and why it is used inbusiness. Prepare common-size balance sheet for Target with the infoprovided below. Assets CashAccounts receivableInventoryOther current assetsTotal current assetsGross plant and equipmentAccumulated depreciationNet plant and equipmentLong-term investmentsGoodwill, trademarks, andother intangible assetsTotal assets $ Dec 31, 2022$20,2684,8733.2772,886$31,304$25,032-10,065$14,96711,512 32,272 $90,055
Required Information [The following information applies to the questions displayed below.] The City of Saltwater Beach established an enterprise fund two years ago to construct and operate Tribute Aquatic Center, a public swimming pool. The pool was completed and began operations last year. All costs, including repayment of debt. are to be paid by user fees. The fund's preclosing trial balance for the current year, is shown below. Cash and Cash Equivalents Accounts Receivable Supplies Restricted Cash and Cash Equivalents Land Buildings and Equipment Accumulated Depreciation-Buildings and Equipment Improvements Other Than Buildings Accumulated Depreciation-Improvements Other Than Buildings Accounts and Accrued Payables Current Portion of Long-Term Debt-Bonds Bonds Payable Net Position-Net Investment in Capital Assets Net Position-Restricted Net Position-Unrestricted Charges for Services Interest and Dividend Income Personnel Expenses Utilities Expense Repairs and Maintenance Supplies…
The list of assets, equity and liability to be filled. Assets Amount (RO) Land and Building Plant and Equipment Furniture and Fitting Inventories Accounts and other receivables Cash Bank 43,789 11,571 11,571 Interest Expenses Taxes 35,097 62,796 40,875 160,531 Equity & Liabilities Equity Share Capital Bonds Payable Accounts Payable Outstanding Expenses Short Term Bank Borrowing The list of Income Statement items is given below. Sales Cost of goods sold General and Administrative Expenses Selling and Marketing Expenses Depreciation Expenses Amount (RO) 165,588 87028 18,469 18,861 6,144 Amount (RO) 78,560 5,591 Additional Information: 1. Dividend paid by the company in the year 2022 is RO 30,277 2. The face value of each share is RO 0.196 3. The market price of shares at end 2022 is Ro 318,685,485.58 162,59 5 34,465 10,58 0 183,36 3 54578 You are required to calculate - Earnings per share, Interest cover, Dividend cover, Price/Earnings ratio, Gross Profit Margin Ratio, Operating profit…
V1 Question: Develop a pro forma statement of cash flow for West Office Plaza. The information given to you is listed below. Property Information: WEST OFFICE Rentable Area 334,000 square feet Age 8 years Number of Stories 15 Number of Tenants 40 Financial Information: Base Rent Average $ 20 per square feet Other Income/Parking/Storage $ 3.20 per square feet Expenses Recoverable from Tenants $ 4.20 per square feet Current Vacancy 5% Expenses: Management/Administration/Security/Ownership $ 698,400 Property Taxes $ 683,500 Insurance $ 433,400 General Operations/Leasing Expense/Marketing $ 675,500 Utilities $ 1,167,600 Janitorial/Cleaning $ 497,500 Business Taxes $ 118,500 Other: Recurring CAPEX/Improvement Allowance $ 708,500
Instructions are down below the chart is provided with the information My Question: Can you provide the net present value of the New and old backhoes including the salvage value. My Question - Please leave the calculations of the Pv factor six digits after the decimal point for example. 0.925925 My Question- Can you also show the math equation for the calculations in the out flow and inflows of the New and Old Back hoes for example. Value of Cash flows and Outflows of the New and Old Backhoes= (...,... + ...,... +etc...... My Question: Can you provide in detail the profitability index of New and Old backhoes My Question: Can you provide the pay back period fro the New and old Backhoes. 1. Evaluate, discuss, and compare whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For the new machine, subtract the salvage value of the old machine to determine the initial cost of the…
Required information Use the following information for the Quick Studies below. (Algo) [The following information applies to the questions displayed below.] Cash Accounts receivable Equipment, net Land Total assets Percent change = Compute the annual dollar changes and percent changes for each of the following items. (Decreases should be entered with a minus sign. Round your percentage answers to one decimal place.) Cash Accounts receivable Equipment, net Land Total assets $ Current Year $ 12,200 63,000 62,000 100,500 $ 237,700 $ Prior Year $ 15,400 28,700 54,400 75,000 $ 173,500 Horizontal Analysis - Calculation of Percent Change Numerator: Current Year Prior Year 12,200 $ 15,400 63,000 28,700 62,000 54,400 100,500 75,000 237,700 $ 173,500 Denominator: Dollar Change Percent Change % % % % %
Reporting land acquisition for cash and mortgage note on statement of cash flows On the basis of the details of the following fixed asset account, indicate the items to be reported on the statement of cash flows:
?Which section of the statement of cash flows is used to report the purchase of a building by issuing a 9-month note payable .Financing activities .A O Investing activities .BO Schedule of noncash investing or financing activity.CO .Operating activities.D O
Reporting Land Acquisition for Cash and Mortgage Note on Statement of Cash Flows On the basis of the details of the following fixed asset account, indicate the items to be reported on the statement of cash flows: ACCOUNT Land ACCOUNT NO. Balance Date Item Debit Credit Debit Credit Jan. 1 Balance 256,200 Feb. 10 Purchased for cash 389,400 645,600 Nov. 20 Purchased with long-term mortgage note 522,900 1,168,500 Item Section of Statement of Cash Flows Added or Deducted Amount Purchase of land for cash Purchase of land by issuing long-term mortgage note
Information on four investment proposals is given below:Investment ProposalA B C DInvestment required ........................ $(90,000) $(100,000) $(70,000) $(120,000)Present value of cash inflows ......... 126,000 138,000 105,000 160,000Net present value ............................ $ 36,000 $ 38,000 $ 35,000 $ 40,000Life of the project ............................ 5 years 7 years 6 years 6 yearsRequired:1. Compute the project profitability index for each investment proposal.2. Rank the proposals in terms of preference.
Required information Use the following information for the Quick Studies below. (Algo) [The following information applies to the questions displayed below.] Cash Accounts receivable. Equipment, net Land Total assets Cash Accounts receivable Equipment, net Current Year $ 12,200 63,000 62,000 100,500 $ 237,700 Express the items in common-size percents. (Round your percentage answers to one decimal place.) Land Total assets Current Year Prior Year $ 15,400 28,700 54,400 75,000 $ 173,500 % % % % 0.0 % Prior Year % % % % 100.0 %
Statement of Cash Flows The following is a list of the items for Lombardo Company's 2019 statement of cash flows: a. depreciation expense, $4,300 b. proceeds from sale of land, $5,500 c. payment of dividends, $5,000 d. net income, $8,000 e. conversion of bonds to common stock, $7,000 k. ending cash balance, $14,000 f. increase in accounts payable, $3,000 Required: Prepare the statement of cash flows. Use a minus sign to indicate cash outflows, a decrease in cash or cash payments. LOMBARDO COMPANY Statement of Cash Flows For Year Ended December 31, 2019 Operating Activities: Net income Adjustment for noncash income items: Add: Depreciation expense g. proceeds from issuance of note, $6,100 h. gain on sale of land, $1,900 i. payment for purchase of building, $13,000 j. increase in accounts receivable, $2,800 Adjustments for cash flow effects from working capital items: