Property Investment P&L Modeling ID-1036
I’ve created initial tabs for the repayment schedules, P&Ls, and the impact of refinancing. You’ll review my work and assist with the following:
• Write-off vs. Refinancing Trade-offs:
I need a tab that compares the financial trade-offs between two strategies: (a) maximizing the potential write-offs of frozen portions of the mortgage through timely payments, and (b) minimizing overall interest payments by refinancing. For example, refinancing could be used to fully repay one of the three loans, but this might forfeit any potential write-offs for that loan. Include charts and tables.
Other Jobs You May Be Interested In
Remote Data Entry, No Experience, $40/hr, Part-Time
Virtual Assistant, $45/hr, Remote, No Experience, Night Job
Entry-Level Remote Data Entry, $50/hr, Evening Job
Customer Support, No Degree, $40/hr, Remote, Weekend Job
Remote Phone Job, $42/hr, Part-Time, College Student Friendly
Virtual Assistant, $40/hr, Remote, No Degree, Night Job
Part-Time Data Entry, $45/hr, Remote, College Student Friendly
Remote Moderator, No Degree, $50/hr, Evening, Weekend Job
Remote Customer Support, $42/hr, Night Job, No Experience
Live Chat Support, $40/hr, Remote, Entry Level, Part-Time
Virtual Assistant, Remote, $42/hr, Weekend, No Experience
Remote Data Entry, $45/hr, No Degree, Night Shift
Part-Time Customer Support, $40/hr, Remote, College Student
Remote Live Chat, $50/hr, Part-Time, Evening/Night Job
Entry Level Phone Job, $42/hr, Remote, No Degree Required
Weekend Data Entry, $45/hr, Remote, No Experience
Remote Virtual Assistant, $40/hr, Evening, Part-Time Job
Remote Moderator, $42/hr, Part-Time, Weekend, No Degree
Data Entry, $45/hr, Remote, Night Shift, College Student Job
Phone Support, Remote, $50/hr, No Experience, Part-Time
Virtual Assistant, No Experience, $42/hr, Remote, Weekend
Remote Customer Support, $45/hr, Part-Time, College Student
Data Entry, Remote, $40/hr, Night Shift, No Degree
Evening Virtual Assistant, Remote, $45/hr, No Experience
Weekend Customer Support, $42/hr, Remote, College Student
Remote Data Entry, $50/hr, No Experience, Evening/Night Job
Remote Live Chat, $40/hr, Part-Time, No Degree Required
Virtual Assistant, $42/hr, Remote, Weekend, Entry Level
Remote Phone Support, $45/hr, Evening, No Experience Required
Data Entry, No Experience, $50/hr, Remote, College Student
Interest Rate Sensitivity Analysis:
Create a tab that allows manual adjustment of interest rates at up to 10 specific future dates. For instance, I may want to model rates decreasing by 50 basis points in 12 months or increasing by 25 basis points in 48 months. The repayment schedules should automatically reflect these changes, and the resulting impact on total repayment amounts and interest payments should be captured. Include charts and tables.
• Enhanced Sale P&L:
Refine the existing sale P&L tab to include dynamic capabilities:
• Automate scenarios that adjust the sale price by increments of +/-10%, +/-15%, etc., starting from an entered base sale price (e.g., 600K → scenarios for 660K, 690K, etc.).
• Add the ability to calculate returns based on the year the property is sold, incorporating all costs and revenues from other tabs.
• Rental P&L Inflation Adjustments:
The current rental P&L assumes constant rental prices. I need this updated to include inflation adjustments, allowing rental income to grow at a set rate every two years. These adjustments should be customizable.
• Automation:
You will automate the fetching of various interest rates.
• Dashboard:
You will create a dashboard containing a set of variables (interest rates, refi rates, sales year etc) that automatically generates and visually represents the rental and sales P&Ls.
Property Investment P&L Modeling ID-1036
