
Closed
Posted
Paid on delivery
I have a 30-year, quarterly solar-project model built in Excel that needs a careful technical tune-up. Right now the debt service coverage ratio is showing as too low and both the project-level and equity IRRs are clearly off, even though the underlying inputs look reasonable. I have already spotted some formula and linking errors, but I want a full review to be confident that every schedule, cash-flow waterfall and profitability metric is sound. The workbook includes the usual integrated statements—income, balance sheet, cash flow—as well as debt amortisation, tax, depreciation and PPA pricing tabs. Your task is to trace the calculations, repair any breakpoints and ensure the outputs reconcile across all sheets. In particular I want you to: • Recalculate and validate DSCR for every period. • Correct the project and equity IRR formulas so they reflect the true cash flows. • Confirm that quarterly cash flows roll up accurately to annual summaries and the three primary statements stay in balance. I will consider the job complete once the model: 1. Full financial statements are fully built and consistent 2. Shows Project IRR and Equity IRR that tie back to the audited cash flows, and 3. Passes a stress test of changed assumptions without breaking circularity or balance. Send back the amended Excel file with any key edits highlighted and a brief change log. If you automate error checks or include sensitivity toggles, that’s a bonus but not essential.
Project ID: 39746775
65 proposals
Remote project
Active 7 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
65 freelancers are bidding on average $149 USD for this job

Hi. I am ranked among Top Business experts with 1,500+ project awards and 1000+ verified reviews on freelancing platforms. I have read your requirements mentioned in the project details. I would like you to see my sample work and check the quality that I can provide. I am an affiliate chartered accountant with 10+ years of experience. i have prepared financial models, pitch decks, business plans for clients based in US, UAE, KSA, Pakistan, UK etc. by carrying out the market research in their specific areas. I have prepared business plans & feasibilities for restaurants, e-commerce, manufacturing, trading, services, IT sector etc. My financial model will contain breakeven analysis, rate of return, payback period, ratio analysis etc. In my deliverables, i will provide you excel sheet containing financial model with separate sheet of assumptions completely linked with financials and act as base information with easy to change setup. Please contact and discuss the details. i can deliver you within 2 - 3 days time
$200 USD in 3 days
8.6
8.6

As a qualified ACCA with over 7 years of financial management experience, I have not only mastered the intricate dynamics of excel and finance but also gained ample experience in tracing, amending, and correcting errors in complex financial models like the one you possess. My dexterity in leapfrogging hurdles like balancing circularity and maintaining file consistency further heightens my suitability for this project. I deeply understand the commitment required to ensure that all schedules, cash-flow waterfalls, and profitability metrics are not only sound but also reconcilable across all sheets. In my decade-long career, I have consistently achieved this precise objective with immaculate bookkeeping and accounting records that remain auditable without any discrepancies. Lastly, my rich portfolio includes running bookkeeping, accounts & financial management services using a diverse range of software including QuickBooks (Desktop & Online), Wave, Myob, Odoo, Zoho Books, Tally and many others. Bellied with this vast array of experience and expertise, I guarantee that I not only fix all the formula and linking errors you've spotted but also conduct an extensive analysis to trace any hidden breakpoints to offer thorough solutions. Consider choosing me for the task; I assure you that I can deliver exactly the quality output you desire.
$140 USD in 7 days
7.8
7.8

As a seasoned data analyst with vast experience in your specific area of concern, I am confident that I can execute the job flawlessly. I have extensive skills in Excel, giving me the ability to effectively trace and correct formula and linking errors, thus ensuring that all schedules, cash-flow waterfalls, and profitability metrics are sound. My deep comprehension of accounting and finance combined with my accuracy in data entry positions me as an ideal fit for this project.
$140 USD in 1 day
7.6
7.6

Hi There, We are well versed in preparing business plans, feasibility studies & financial models for different purposes including investment, bank loan, immigration, internal use etc. We prepare all our plans as per specific requirements of employer and prepare a robust model on excel with minimum manual inputs. Because of our extensive knowledge in advanced financial modelling, we have served numerous employers at local & international level. Our financials have all required elements such has underlying assumptions, balance sheet, profit & loss, cash flow statements and include calculations of IRR, payback period, breakeven point etc. We are happy to share our sample work with you. Kindly contact us and give us a chance to present our services.
$150 USD in 3 days
6.9
6.9

Hello, I am a business & financial Advisor providing services of writing business plans, feasibility studies, financial models & business valuation reports. I am CA finalist from Institute of Chartered Accountants of Pakistan and working in this field since 2010. During my 12 years' professional career, i have had the pleasure of representing my clients to international investors and discuss new business ideas & prospective plans for fund raising. We conduct secondary research with detailed analysis of the market including market share, competitors, pricing etc Please see my portfolio to check my sample work. We are well versed in preparing financial projections tailored to the business needs & market demographics and based on solid assumptions. i know how to present information to investors and what to include to get his attention. Please send me message and see my work. I am available to discuss further about your business, financial model and market demographics. Please contact and discuss the details.
$140 USD in 4 days
6.8
6.8

Hi Zviko, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist with your Solar Project Financial Model Fix. I have carefully reviewed the project requirements and am eager to help fine-tune your Excel model. I would like to connect with you in chat to discuss the specifics of your project further. I am keen on ensuring that the debt service coverage ratio, project-level and equity IRRs are accurately reflected in the model. My goal is to validate all calculations, correct any errors, and ensure the accuracy and consistency of the financial statements. Looking forward to discussing this project with you in more detail. Regards.
$30 USD in 1 day
6.9
6.9

As a highly experienced and qualified Chartered Accountant with a particular focus on financial consultancy, I feel confident in my abilities to not only fix the errors you've identified in your solar-project model but also enhance its overall performance. Over my 9-year career, I've built a strong reputation for meticulousness, consistently producing financial forecasts and models that are highly accurate and compliant with relevant regulations. My speciality in financial modeling aligns perfectly with the tasks you've set forth. Not only can I track formula errors, rebuild break points, and ensure consistency across all sheets as requested, but I can also take your model a step further by incorporating automated error checks and sensitivity toggles. These would not only future-proof the model but also provide extra assurance that it remains robust and reliable even under changed assumptions. Ultimately, my goal is to provide you with more than just an error-free model; I aim to deliver value. With my skills in accounting and finance, I will ensure that your solar project financials are in perfect alignment, recovering optimal Debt Service Coverage Ratio (DSCR) figures, refining Project and Equity internal rate of return (IRR) formulas for precise cash flow reflections.
$140 USD in 7 days
6.1
6.1

Hi, I am an experienced certified Cost And Management Accountant (ACMA) and Financial Analyst and Certified Public Accountant (CPA) having more than 7+ years' experience in finance. I have gone through your project with interest and it seems a perfect match with my skills. May I ask you a few questions about your project? What’s the principal activity of your business? Do you have any specific reporting requirements? When would you like to start? I have been providing Financial Modelling, Business Analysis, Business Plan, Financial Analysis, Financial Forecasting, Excel, Advance Excel, Visual Basics, Payroll, Data Processing, Data Entry, Finance, Accounting, Financial Research services and serve my more than 3+ years with top rated Audit firm (KPMG) during which I have dealt with a number of clients and provided them extremely satisfied services. Apart from that, I am also highly proficient in different accounting software packages like Excel, Advance Excel, Quick Book, Intuit Quick Book ,XERO, Microsoft Dynamic, Enterprise and more. I am a fast learner, problem solver, detail oriented and highly organized. Looking forward to hearing from you soon! Looking forward to hearing from you Thanks & Regards. Zakwan
$100 USD in 1 day
6.3
6.3

Hi, I specialize in creating realistic, investor-ready financial models that speak the language of banks, VCs, and strategic partners. Whether youre launching a new venture or scaling an existing one, Ill help you forecast your growth with clarity and confidence. What Youll Get: Fully Customized Financial Model 3- or 5-Year Pro Forma Statements (P&L, Balance Sheet, Cash Flow) Monthly, Quarterly & Annual Forecasts Revenue Drivers, Expense Breakdown, and Payroll Schedule Startup Metrics: Burn Rate, Runway, CAC, LTV Valuation: DCF & Market Comparables Break-Even Analysis & Sensitivity Scenarios IRR, NPV, and Payback Period Cap Table (Equity, Loans, Convertibles) Investor Summary with Key Financial Ratios Visual Dashboard with Charts and Graphs Optional: Pitch Deck or Business Plan Integration
$220 USD in 7 days
6.6
6.6

Hello Zviko M. I hope you're doing well. I understand you're looking for Solar Project Financial Model Fix I am the ideal candidate for your project. I have read the provided job description and I understand what you are looking for. I have over 10+ years of experience Accounting, Excel, Finance, Mathematics, Data Analysis, Financial Modeling, Financial Consulting .Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. ✅ No Upfront Payment ✅ Release Milestone After Completion ✅ 100% Project Completion Rate You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$100 USD in 2 days
6.2
6.2

Hi, I am Bilal Khan, a fellow CPA/CA, a real time practicing chartered accountant and partner at Baker Tilly - the 8th largest CA firm in the world. I have read your requirements. I will audit the 30-year financial model for the solar project, as per the requirements you have laid down, addressing the given scope. Why you should choose me, here are a few reasons? 1. I know exactly what you want, and why you need assurance on your financial model. 2. I bring practical financial modelling experience to you, based on real-time solar projects such as QSPPL (Pak). 3. I WILL ALSO ADD MY PROFESSIONAL INPUT TO THE FINANCIAL MODEL, MAKING IT HIGHLY RELEVANT AND APPROPRIATE TO THE SOLAR PROJECT SECTOR. 4. You will get the quality of Big8 firm, which would be a plus for your investment endeavours. Let's discuss the details at your earliest and start working right away. Regards, Bilal K.
$200 USD in 7 days
5.8
5.8

Hello, Top of the day. Trust you are doing great. I''d like to work on your project. I am a Professional Accountant, Researcher and Writer with wealth of experience in report writing, academic writing, finance, accounting, financial reporting, management accounting, financial management, corporate finance, budgeting, financial planning and analysis, auditing and diverse other fields. I have extensive experience in doing feasibility study, preparing business plans, designing marketing plans and strategy. I have magnitude of experience in preparing financial statements, investment appraisal, financial modelling - making financial projections/planning, business plans and linking the models together, ensuring consistency, simplicity, understandability and ultimately achieving its objective. I am highly proficient in the use of excel for solving business problems. I am happy to work on your solar project financial model fix. I have strong flair for business analysis, finance and accounting and the use of excel in providing solutions. I look forward to your task as this would afford me the opportunity to diversify my experience and contribute to the success of your endeavour. I am also open to other opportunities of work you may have. My ultimate objective is to keep my customers & clients satisfied and delight them beyond expectation. I await your positive response & consideration. A trial will make the difference. Thank you.
$200 USD in 7 days
5.4
5.4

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$190 USD in 3 days
5.8
5.8

Hello Zviko M., I understand that you require a comprehensive review and technical tune-up of your 30-year, quarterly solar-project financial model in Excel. I will meticulously trace calculations, correct formula errors, and ensure that all schedules, cash-flow waterfalls, and profitability metrics are accurate and reconcile across all sheets. With my expertise in Accounting, Financial Modeling, and Financial Consulting, I will recalculate and validate DSCR, correct IRR formulas, and ensure accurate quarterly to annual cash flow summaries. Effective communication will be maintained throughout the project to meet your expectations. Best regards.
$140 USD in 7 days
5.1
5.1

am an experienced Electrical Engineer and Data Scientist with a unique blend of expertise in engineering, software development, data science, business analysis, and academic writing. My multidisciplinary skill set enables me to deliver end-to-end solutions — from hardware design to data-driven insights, financial modeling, and professional reporting. ? Electrical & Electronics Engineering I specialize in digital systems, PCB design, circuit development, and FPGA programming (Quartus). I design and implement embedded solutions using Arduino and MATLAB Simulink while applying advanced techniques in signal processing, image processing, and mathematical modeling. With MATLAB, I create powerful simulations, system models, and 2D/3D data visualizations for research and industrial applications.
$30 USD in 7 days
5.1
5.1

I am sure you will give me more projects after this. I have done a similar project a week ago. I am interested to do this project too and ready to complete this within the timeline. Pls check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Note: Budget Negotiable.
$140 USD in 7 days
5.0
5.0

My name is Rabia Faisal, I am working in the writing industry since 2011. During this time, I have served countless clients with a full amount of satisfaction by providing them with TOP Quality Solutions. I have command of all references APA, Harvard, IEEE, MLA & Chicago, etc. I will provide plagiarism-free work with 100 percent accurate grammar within your given deadline. Please message me to get Top Class Services. I am waiting; https://www.freelancer.com/u/TopWritingGuru
$30 USD in 1 day
4.9
4.9

Dear Zviko M., I am excited about the opportunity to work on your 30-year, quarterly solar-project model in Excel that requires a comprehensive technical review and tune-up. I am confident in my ability to identify and rectify formula errors, ensure accurate calculations for debt service coverage ratio and project-level IRR, and guarantee the consistency and integrity of all financial statements and profitability metrics. I am committed to delivering a meticulously reviewed and error-free model that accurately reflects the underlying inputs. Regards, swatijain5558
$158 USD in 3 days
4.4
4.4

With over 7 years of experience in finance, I feel confident that I am the right person to handle your solar project financial model fix. My strong background in financial modeling includes building, reviewing and refining complex models, just like the one you have described. I have a reputation for delivering high-quality work that aligns with client expectations, and that is why my past projects reflect a 5/5 rating. In addition to my finance skills, my proficiency in Excel means that not only can I locate and repair any errors in your model, but I can also enhance its functionality for future use. Whether it is automating error checks or adding sensitivity toggles, I possess the expertise to make them a reality.
$100 USD in 4 days
5.0
5.0

Hello there, With extensive experience in statistical and predictive analytics, My proficiency in SPSS combined with my programming skills in Python will not only ensure an effective data analysis but also allow for flexibility and automation, optimizing efficiency throughout the process. Throughout my career, I have consistently proven my problem-solving mindset transforming complex datasets into clear and actionable insights that clients can use to drive their business forward. Data cleaning and transformation is an often-overlooked area of importance; however, it's where precise analysis begins. My vast experience in this area ensures thorough sorting of your data for accurate analysis - leaving no stone unturned. Lastly, I recognize that clear communication is vital to successful project completion. I assure you of my commitment in communicating regularly and effectively throughout this project, leaving no room for ambiguities. Trusting me with this project will not just avail you of a qualified individual but also someone who is dedicated in leveraging their knowledge and experience for unparalleled client satisfaction.
$30 USD in 1 day
4.4
4.4

Johannesburg, South Africa
Payment method verified
Member since Nov 20, 2013
$30-250 USD
$750-1500 USD
$30-250 USD
$100 USD
$50 USD
$250-750 CAD
$500-1000 USD
$250-750 USD
₹750-1250 INR / hour
$500-1000 USD
₹750-1250 INR / hour
$10-30 USD
₹750-1250 INR / hour
$5-20 AUD / hour
₹5000-100000 INR
€30-250 EUR
₹12500-37500 INR
₹600-1500 INR
$250-750 USD
£20-250 GBP
₹37500-75000 INR
₹1500-12500 INR
$10-30 USD
$250-750 USD
$750-1500 USD