
In Progress
Posted
Paid on delivery
I am preparing a graduate-level finance submission and need a focused financial ratio analysis on a publicly traded firm. The emphasis is strictly on liquidity and profitability performance, tracked across the last three fiscal years and benchmarked against a close peer and the wider industry average. For the ratio analysis, you must 1) Set up (create) a table, in the excel provided, containing ratios for the firm provided and ratios for a benchmark/industry for at least 4 years (if data provided is incomplete, use AI and the web to collect or complete your data – using four-digit NAICS in searching for benchmark is the common practice in business). 2) There should be 2 (or more) ratios in each (three out of four) of the following categories: • Liquidity (or short-term solvency) • Profitability • Long-term solvency • Asset management (or turnovers) 3) Create a line graph for the 2 company ratios and 2 matching industry/benchmark ratios, using the table created in point 1), in the excel file. There should be at least 3 graphs, one for each of the categories Here is what I expect: 1. A clean, fully linked Excel model that sources figures directly from provided financial 2. A 1,200-1,500-word narrative explaining year-over-year movements, primary drivers behind each ratio, and any warning signs or positive outliers that an investment professional would use I consider the work finished once the numbers tie back to the published statements, the analysis offers clear, actionable insights, and all data sources are properly cited. A seven-day turnaround is preferred, though let me know right away if another timeline would improve quality. More detailed information will be provided upon hire.
Project ID: 40481520
64 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
64 freelancers are bidding on average $397 USD for this job

Hi there, We can complete the ratio analysis with a clean, fully linked Excel workbook, benchmarked across the required periods, plus a concise graduate-level narrative tied to published statements and cited sources. We will build the tables, check the formula links, and produce the requested charts for liquidity and profitability, while keeping the analysis commercial, clear, and evidence-based. We will stay within the provided files and keep all work on Freelancer. Best Regards, 8veer
$650 USD in 7 days
7.4
7.4

Hi there, I understand you need a graduate-level financial ratio analysis that combines a fully linked Excel model with a professional narrative evaluating liquidity, profitability, solvency, and asset-management performance over multiple years against both a peer and industry benchmark. My approach will be to build a structured Excel workbook that calculates all required ratios directly from the supplied financial statements. Where benchmark or industry data is incomplete, I will research and compile comparable industry metrics using appropriate NAICS-based benchmarking and credible financial sources. I will create a ratio table covering at least four years, including a minimum of two ratios in each required category, and develop clear line charts comparing company performance against peer and industry trends. The analysis will then be translated into a 1,200–1,500-word report explaining year-over-year movements, underlying financial drivers, strengths, weaknesses, and notable trends. The discussion will focus on the implications of liquidity, profitability, solvency, and efficiency performance from an investor and financial management perspective, with all sources properly cited. Is there a specific publicly traded company and benchmark peer already selected, or would you like assistance identifying the most appropriate comparable firm and industry benchmark? I’m ready to start immediately. Warm Regards, Aneesa.
$250 USD in 2 days
7.1
7.1

* PLEASE CHECK OUT MY PORTFOLIO TO SEE PREVIOUS WORK SAMPLES * As a Business & Financial Consultant and Investment Banker (MBA – Strategy & Finance), I specialize in financial analysis, financial modeling, and investor-ready reporting, making me well-suited for your project. What I can deliver: • Robust Excel financial models linked to reliable financial data sources • Clear analysis of financial movements, ratio drivers, trends, and key warning signs/outliers • Investor-style financial narratives that explain the story behind the numbers • Strong focus on accuracy, financial precision, and data validation • Executive-level insights suitable for graduate submissions and professional scrutiny Having worked across Tech, Healthcare, E-commerce, EdTech, and startups, I provide not just numbers, but meaningful, actionable insights with a strategic perspective. Best regards, Shashwat S.
$250 USD in 5 days
7.4
7.4

With over a decade of managerial experience in finance and accounting, as a Manager Accounts, I bring seasoned expertise to conducting meticulous financial analysis such as the one required for this project. As a proficient user of Excel, I am highly skilled in creating insightful data models that present complex information clearly and coherently, as you’ve specified. I made many analysis with related other companies. In preparing your graduate-level finance submission, I value the importance of comprehensive research. My vast experience includes leveraging AI tools and web searches to ensure comprehensive data collection even when faced with incomplete information. Additionally, my ability to work with all published statements equips me well to deliver on the requirements of setting up a focused financial ratio analysis, complete with well-designed tables and full excel integration. To exceed your expectations for this project, I intend to go beyond simply producing ratios and graphs. My value-added services extend to providing a 1,200-1,500 word narrative explaining the rationale behind each year-over-year movement in ratios along with any positive outliers or alarms an investment professional might glean from the study. You can also trust in my thorough citation of all data sources used throughout the project which further attests
$350 USD in 5 days
6.4
6.4

Hello I can deliver a complete financial ratio analysis with a fully linked Excel model, peer/industry benchmarking, professional charts, and a graduate-level narrative report. I have experience in financial statement analysis, ratio modeling, and industry research, ensuring all calculations are accurate, traceable to published financial statements, and supported by credible sources. I can provide clear insights into liquidity, profitability, solvency, and asset management performance, highlighting key trends, drivers, and investment implications. Looking forward to discussing the company details and project requirements. ..R..
$500 USD in 7 days
5.9
5.9

Hello, I am a finance analyst who will build a fully linked Excel model calculating liquidity and profitability ratios (minimum 2 per category across 3+ categories) for your publicly traded firm and its peer/industry benchmark over at least four fiscal years—using your provided statements and completing missing data via web/NAICS-based searches (cited properly). I will create at least three line graphs (one per category) comparing company vs. benchmark ratios, then deliver a 1,200-1,500-word narrative explaining year-over-year movements, drivers, warning signs, and outliers from an investment professional’s perspective. All sources will be cited, and figures will tie back to published statements. Ragards, Zafar
$280 USD in 7 days
6.2
6.2

Hi, With seven years of experience in financial analysis, I am well-equipped to deliver a precise and detailed financial ratio analysis for your graduate-level submission. I will create a comprehensive Excel table that includes liquidity and profitability ratios, adhering strictly to the benchmark and industry standards. I will ensure that all data is accurately sourced, employing advanced research methods to enhance any missing information as necessary. My approach will provide a thorough analysis across the last three fiscal years, with a focus on clarity and insight. I will maintain clear communication throughout the process, ensuring you are updated on progress and able to provide any additional information you may wish. In addition to the Excel model, I will develop a narrative that offers a deep dive into the year-over-year movements and the factors influencing each ratio, culminating in actionable insights for investment considerations. I am committed to following proper processes to ensure that the work is reflective of rigorous standards and meets the agreed deadline. Rest assured, I am dedicated to ensuring all figures tie back to published financial statements accurately, and all data sources will be appropriately cited for your review. Thank you for considering my proposal, and I look forward to the opportunity to assist with your project.
$500 USD in 7 days
5.3
5.3

I understand you need a detailed financial ratio analysis for a graduate finance submission, focusing specifically on liquidity and profitability for a public company over three fiscal years, benchmarked against a peer and industry average. I recently completed a similar project for a fintech client, accurately calculating and presenting their key performance indicators against competitors. I will populate your provided Excel sheet by calculating at least five relevant liquidity ratios (e.g., Current Ratio, Quick Ratio) and five profitability ratios (e.g., Gross Profit Margin, Net Profit Margin) for the target company, its peer, and industry averages, using data from the last three fiscal years. Where necessary, I will leverage financial databases and web scraping tools to ensure data completeness for all four years as requested. Given the emphasis on liquidity and profitability, which specific liquidity ratios do you consider most critical for this analysis? Ready to start as soon as you confirm scope.
$558 USD in 21 days
5.3
5.3

Dear Client, I have carefully reviewed your project and understand that you need a detailed public company financial ratio analysis supported by clear interpretation of financial statements and meaningful insights. I have strong experience in financial analysis, including interpreting balance sheets, income statements, and cash flow statements, as well as calculating and explaining key financial ratios for publicly listed companies. I can deliver a structured and insightful analysis including: • Liquidity, profitability, leverage, and efficiency ratio calculations • Horizontal and vertical analysis of financial statements • Trend evaluation across multiple reporting periods • Clear interpretation of what each ratio indicates about company performance • Identification of key financial strengths, risks, and unusual movements • Well-organized report in professional format (Word or PDF + Excel if needed) My focus is not just calculating ratios, but explaining the financial story behind the numbers so the analysis becomes decision-useful and easy to understand. I am ready to start immediately and deliver high-quality work within your timeline. Best regards,
$250 USD in 2 days
5.2
5.2

Hi, this is a finance-analysis job more than a software build, but the deliverable is still a structured data model with traceability, validation, and clean output in Excel. The real risk is source consistency across company, peer, and industry data so the ratios tie back cleanly and the comparisons are methodologically defensible. The closest relevant work on my side is NYSE Day Trading Bot Development, where the core discipline was handling market data accurately and documenting logic clearly. Custom Feature Development & Integration is also relevant in the sense of auditing an existing artifact, identifying gaps, and delivering a maintainable final structure. I usually structure work like this by separating source extraction, normalized ratio calculations, benchmark mapping, and narrative interpretation. That avoids the common failure mode where the writeup looks polished but the workbook cannot be audited back to published statements. For this kind of analysis, reliability comes from explicit source citations, locked calculation logic, and clear treatment of any missing benchmark data or classification assumptions. If useful, I can first sketch the workbook structure and ratio mapping before the full narrative is drafted. Thanks, Hercules
$500 USD in 7 days
5.1
5.1

Public Company Ratio Analysis requires reconciling multi-year financial statements against industry benchmarks while isolating liquidity and profitability drivers—a task that demands precision in data sourcing and narrative interpretation that distinguishes signal from noise. This submission will deliver a fully linked Excel model pulling figures directly from SEC filings, with liquidity ratios (current, quick), profitability metrics (ROE, net margin), long-term solvency coverage, and asset turnover tracked across four fiscal years. Peer and NAICS-matched industry benchmarks will be sourced and embedded as dynamic references. Three separate line graphs will isolate category-level trends, making year-over-year movement immediately visible. The narrative component will move beyond mechanical calculation—identifying what drove each ratio shift, flagging deterioration patterns an institutional investor would scrutinize, and noting outliers that signal operational or capital structure changes. All figures trace back to published statements with source citations embedded. Delivery in six days. All revisions included until the analysis ties perfectly.
$250 USD in 1 day
5.1
5.1

With a background in financial analysis and expertise in ratio analysis, I can provide you with a comprehensive report on liquidity and profitability metrics for the specified firm and its industry peers. Could you please clarify if you have a preference for the industry benchmarking approach based on specific NAICS codes or would you prefer a broader industry average comparison? Regards, CA. Swati Jain, CPA | Indian CA & CS
$560 USD in 1 day
4.6
4.6

As a highly experienced Data Scientist and Programmer, my proficiency in handling large datasets and creating insightful visualizations would be instrumental in delivering a comprehensive financial ratio analysis that meets your specific needs. My adeptness in using Python and Excel is perfect for creating clean, fully linked Excel models that source figures directly from financial statements. Moreover, I'm proficient in some of the most powerful libraries like Pandas, Numpy, Matplotlib, Seaborn, etc., which ensure I can effectively track and analyze liquidity and profitability performance across the past three fiscal years of the company you provided.
$250 USD in 2 days
4.3
4.3

Having built my career over the last decade primarily in design, I have fine-tuned skills that translate seamlessly to this project. Let me start by telling you how I handle a complex assignment like this one. My workflow strategy revolves around maintaining excellent communication like being available online 24x7 for any queries to ensure no detail is overlooked during the process of data collection and analysis. I offer the same commitment to this project. Regarding your requirement to create a fully linked Excel model and tables for financial ratios, I assure you of my Excel proficiency. Whether it's data manipulation, creating formulas or graphs like line graphs, I can do it all deftly on Excel. Furthermore,. Best Regards Pinky
$276 USD in 2 days
4.9
4.9

Hi, This project involves more than ratio calculation alone—it requires linked financial modeling, benchmark research, and clear interpretation of what the numbers actually mean over time. I can support a structured analysis that includes: • Excel ratio tables linked to financial statement data • Four-year company and benchmark/industry comparison • Liquidity, profitability, solvency, and asset-management ratios • Line graphs and trend visualization within Excel • Research and sourcing for benchmark/industry data where needed • A concise analytical narrative explaining movements, drivers, strengths, and warning signs supported by the financial results My approach is to keep the model transparent and traceable so figures tie back clearly to source data and benchmarking assumptions remain easy to verify. A few quick questions to scope accurately: 1. Has the public company already been selected? 2. Should peer and industry benchmark selection be part of the assignment? 3. Is there a required citation or academic writing format? 4. Will the financial statements already be included in the provided Excel or should missing data be researched? Once I review the materials and company selection, I can confirm the analysis workflow and turnaround.
$300 USD in 7 days
3.7
3.7

Hi, I can assist with the complete financial ratio analysis, Excel model creation, benchmarking, charts, and written report. I have experience working with financial data, Excel, and research-based projects. I will ensure all ratios are accurately calculated, properly sourced, and supported by clear analysis. I am ready to start immediately and can deliver high-quality work within your preferred timeline. Thank you for your consideration.
$250 USD in 4 days
3.2
3.2

With a wealth of experience in financial analysis such as the task at hand, I am confident in my ability to complete your Public Company Ratio Analysis to an exemplary standard. My investment-grade financial modeling skills are aligned with what you're seeking, and this has enabled me to deliver powerful insights for strategic decision making in similar projects for startups, investment teams, and executive leaderships. My eye for detail, depth of work and comprehension of your project's key objectives ensures that I will build a clean, well-referenced excel model that sources figures from the provided financials - tying back all numbers to the published statements. Moreover, an essential part of any well-executed financial analysis is an accurate interpretation that identifies year-over-year movements and their primary drivers. Based on your preference for a 1,200-1,500-word narrative, I will provide not only a narrative analysis but also anticipate and explain potential warning signs or positive outliers through each year's performance. This adds considerable value as prudent investors would bank on such compelling and comprehensive narratives. Lastly, my extensive range of professional presentations and business writing skills means I can showcase the results as attractive visuals and coherent narratives while maintaining the technical accuracy needed for well-presented Excel models.
$350 USD in 7 days
3.2
3.2

Hi There, I came across your project requiring a public company ratio analysis and wanted to offer my support. As a Certified Chartered Accountant with years of experience in financial analysis and reporting, I deliver clear, accurate, and actionable insights professionals can trust. Here’s how I can assist you: -Build a clean, fully linked Excel model sourcing figures directly from published statements. -Organize ratios across liquidity, profitability, long-term solvency, and asset management, benchmarked against peers and industry averages. -Create tables and line graphs to illustrate year-over-year movements, trends, and outliers. -Provide a 1,200–1,500 word narrative explaining drivers behind each ratio, highlighting warning signs or positive signals. Clients describe me as dependable and precise—I take pride in producing work that ties seamlessly to published data and offers academically rigorous, practical insights. My goal is to help you submit a polished, professional-grade analysis within your preferred seven-day timeline. If this sounds like the support you’re looking for, I’d be delighted to discuss further. Let’s ensure your submission is comprehensive, insightful, and fully compliant with academic standards. Looking forward to hearing from you, Oluwatobiloba
$450 USD in 3 days
3.4
3.4

Hi, I can assist with your graduate-level finance assignment by preparing a comprehensive ratio analysis supported by a fully linked Excel model and a professionally written narrative. I have experience with financial statement analysis, ratio benchmarking, industry research using NAICS classifications, Excel modeling, and academic/business finance reporting. I will build the required ratio tables, source and validate benchmark/industry data where necessary, create the requested charts and trend analyses, and ensure all figures reconcile with the published financial statements. The written analysis will clearly explain year-over-year changes, key performance drivers, strengths, risks, and comparative insights against both the selected peer and industry averages. All sources will be documented appropriately, and the final deliverables will be organized, easy to review, and suitable for graduate-level submission. Once you share the company details and provided files, I can review the scope and confirm a timeline that balances accuracy, quality, and your submission deadline.
$300 USD in 7 days
2.8
2.8

This project aligns well with my background in financial analysis, ratio analysis, and Excel-based financial modeling. As a Chartered Accountant with over 5 years of experience, I have prepared financial analysis reports for academic, investment, and business purposes, ensuring that all calculations are accurate, fully traceable, and supported by reliable sources. I can create a professionally structured Excel model containing the required company, peer, and industry benchmark ratios for at least four years, using the provided financial statements and supplementing any missing benchmark data through credible public sources where necessary. The workbook will include fully linked calculations, clear assumptions, ratio tables, and trend graphs that compare company performance against peers and industry averages. Beyond the Excel work, I will prepare a well-written 1,200–1,500-word analysis explaining year-over-year movements, key drivers behind each ratio, notable strengths and weaknesses, and the implications from an investment perspective. All figures will be reconciled to the published financial statements, and all external data sources will be properly referenced. I understand the importance of academic quality, accuracy, and clear financial interpretation. I can start immediately and can comfortably deliver within your preferred seven-day timeframe. I would be happy to review the company details and source materials before we begin.
$300 USD in 4 days
1.5
1.5

Atlanta, United States
Payment method verified
Member since Jan 15, 2026
$30-250 USD
₹400-750 INR / hour
$2-8 CAD / hour
₹9000-36000 INR
₹750-1250 INR / hour
$30-250 USD
$250-750 USD
₹600-1500 INR
€30-250 EUR
$1500-3000 USD
₹1500-12500 INR
₹750-1250 INR / hour
$15-25 USD / hour
$30-250 NZD
₹1500-12500 INR
₹1500-12500 INR
₹750-1250 INR / hour
$30-250 USD
₹400-750 INR / hour
€250-750 EUR
$150-300 USD