How to calculate financial ratios in excel jobs
I'm looking for a freelancer who can help me create an Excel sheet to manage match schedules. This isn't just a simple schedule, but a comprehensive table of teams and their selections. Key Features: - A visual calendar for easy understanding of match schedules - Inclusion of team logos in the table Ideal Skills: - Advanced Excel skills - Experience in sports data management - Ability to create visually appealing and functional spreadsheets I want the final product to be a user-friendly and detailed Excel sheet that can help me keep track of upcoming matches and team selections.
...proposal, costs and means, DSCR calculation, financial projections for 7 years, and a conclusion. In detail, the report should include: - Promoter's background and proposal: A brief overview of the project's initiator and their proposal for the poultry farm. - Cost and means with DSCR calculation: An in-depth analysis of the costs associated with the project, focusing on infrastructure and equipment, as well as feed and labor. This section should also include a thorough calculation of the Debt Service Coverage Ratio (DSCR) using standard financial formulas. - Financial projection for 7 years: A detailed financial forecast for the project spanning seven years. - Conclusion: A summary of the findings and projections. Ideal skills for ...
I need expert assistance in managing my fixed income securities portfolio. The tasks involve analysis and valuation of the securities, optimizing the portfolio for the best possible performance, and tracking and reporting on the portfolio's progress. An ideal freelancer for this project would: - Have extensive experience in managing fixed income securities. - Be highly skilled in securities analysis and valuation. - Be proficient in portfolio optimization techniques. - Have a strong background in financial reporting and tracking. The ultimate goal of this project is to generate detailed, comprehensive reports on the portfolio's performance.
I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.
I'm in need of a pro forma financial statement for a storage unit business. This pro forma is aimed primarily at securing funding, so it needs to be compelling and detailed enough for potential investors. Key Requirements: - Expertise in financial forecasting and modeling - Prior experience with retail-based pro formas, particularly in the storage or similar industry - Ability to create a detailed income statement projection The ideal freelancer for this project should have a strong background in finance and business, preferably with experience in creating pro formas for securing funding. You should be able to create a persuasive income statement that will aid in attracting potential investors. ...
I'm seeking a mid-level Outside Sales Representative with a strong background in the finance industry. Key Responsibilities: - Engaging potential clients and driving sales from outside the company premises. - Building and maintaining relationships with existing clients. - Understanding and promoting the company's financial products and services. Ideal Skills and Experience: - Proven experience as an Outside Sales Representative, preferably in the finance sector. - Excellent communication and interpersonal skills. - Strong understanding of finance and sales principles. - Ability to deliver engaging presentations and close deals.
...for an Excel expert to assist with formatting my pilot logbook spreadsheet. The logbook is used to track flight data, and I need help with both cell formatting and calculations. Key Requirements: - Expert level knowledge in Microsoft Excel - Experience in spreadsheet formatting, including cell formatting (e.g., colors, borders) and data organization (e.g., sorting, filtering) Specific Tasks: - Help with Formulas and calculations - Help calculating total flight hours and flight time by aircraft type - Create a formula for inputting an aircraft registration and having the corresponding aircraft type appear in the next cell. Ideal freelancer should have: - Strong attention to detail - Prior experience with pilot logbooks or simila...
I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.
I have a 22-page PDF that needs to be converted into an Excel workbook. Each page of the PDF should correspond to a separate tab in the Excel file. The project involves reformatting images and adding specific information. Specific Tasks: - Convert each page of the PDF into its own tab in the Excel workbook. - Reformat the content of images on each page into text within Excel. - Add ordering information and my logo to the bottom of each page. - Transform images into text using OCR (Optical Character Recognition). Ideal Skills: - Proficiency in Excel and PDF conversion. - Experience with OCR software or tools. - Attention to detail for accurate transcription and formatting.
To export PDF with enhanced data from excel sheet and chatgpt integration. The goal is to automate this process including data extraction, data enhancement, pdf export
...seeking a finance expert to prepare a comprehensive financial model for my metal can manufacturing project. The model should assess the feasibility of the project, with a focus on several specific financial outputs. Key Deliverables: - Cash flow projections - Profit and loss statements - Break-even analysis - Financial Ratios - Market Research I have some existing financial data and projections available for this project, which I'll share with the successful freelancer. Ideal Skills: - Strong background in finance and financial modeling - Experience in the manufacturing sector, particularly with metal can production - Excellent analytical skills - Proficient in market research and financial ratio analy...
More details: What specific tasks do you need help with in Microsoft Excel? Data analysis What type of data analysis are you looking for? Market research analysis Which financial metrics are you most interested in analyzing? Cash flow
I am looking for a seasoned Salesforce Marketing Cloud expert with a deep understanding of Open Dental. The primary goal of this project is to enhance our data analytics and reporting capabilities. Key Requirements: - Integrate patient records and appointment history from Open Dental into Salesforce Marketing Cloud - Generate insightful reports on patient treatment trends, appointment booking patterns, and our financial performance Ideal Skills & Experience: - Proven experience with Salesforce Marketing Cloud - In-depth knowledge of Open Dental - Exceptional data analytics and reporting skills - Ability to translate complex data into understandable and actionable insights
I'm seeking an experienced developer to create an Excel-based chatbot for me. The chatbot needs to handle natural language processing (NLP) to enable intuitive user interactions. Key Skills Needed: - Proficiency in Excel and chatbot development - Experience with natural language processing (NLP) - Ability to create user-friendly interfaces - Strong communication skills for understanding project requirements
I'm a startup company in the Supply Chain Finance sector in India. I need a comprehensive financial project report focusing on market analysis and incorporating various financial models. Key Aspects: - Conduct an in-depth market analysis using internal company data, industry reports, and public financial data. - Develop key financial models including cash flow projections, break-even analysis, and revenue forecasting. Ideal freelancer should have: - Strong expertise in market analysis and financial modeling. - Prior experience in the Supply Chain Finance industry will be a plus. - Excellent data interpretation skills using diverse data sources.
Just calculate simple commission formula and add to users only. Work with ftp only.
I'm looking for an expert in keyword research to help improve the search rankings of my tutorial and how-to videos on YouTube. The primary goal is to identify effective keywords that will enhance visibility and ranking on YouTube's search platform. Ideal Skills and Experience: - Proficient in YouTube SEO and keyword analysis - Experience with tutorial and how-to video optimization - Familiarity with YouTube's search algorithms - Ability to deliver actionable insights and strategies Steps: - Find keywords in VidIq - Ensure The keywords are relevant to stock market only - All the keywords has to scored above >70 only to be accepted - The keywords has to be not the one we alr...
I'm seeking a skilled Excel expert to create an interactive, monthly reusable Excel document based on the Georgia ST-3 form. I've got a PDF version, but I need a tailored Excel one with formulas to compute specific totals. Key Requirements: - The layout should be similar to the PDF but does not need to match exactly. - Formulas to total Sales Tax and State Tax - Inclusion of a 'Clear' button to reset data - Pre-filled templates for each month Ideal skills for this job include advanced Excel proficiency, experience with tax forms, and a good eye for detail.
I'm looking for an experienced Python developer to automate the transfer of data from Excel to PowerPoint for me. This task includes transferring data and creating slides, generating charts and inserting them into the slides, and formatting the slides based on templates. Specific Requirements: - Data Transfer: Text data, numerical data, and charts/graphs need to be transferred from Excel to PowerPoint. - Slide Organization: Each Excel sheet should correspond to one PowerPoint slide. Ideal Candidate: The ideal candidate for this project would be someone with extensive experience in Python, as well as familiarity with working with Excel and PowerPoint. Strong attention to detail is a must, as the slides need...
************************ Don't Bid To This Project If You're Not Based In Malaysia ************************ We are seeking a highly driven and skilled Sales Development Executive with extensive knowledge of the automotive spare parts industry. The ideal candidate will play a pivotal role in expanding our international market presence, identifying growth opportunities, and fostering strong partnerships with key stakeholders across global markets. This role offers a competitive base salary, a fixed commission on each successfully closed deal, comprehensive medical insurance, and allowances, ensuring direct recognition and rewards for contributions to business growth. ***Key Responsibilities*** 1. Identify and pursue new business opportunities in...
I need expert assistance in managing my fixed income securities portfolio. The tasks involve analysis and valuation of the securities, optimizing the portfolio for the best possible performance, and tracking and reporting on the portfolio's progress. An ideal freelancer for this project would: - Have extensive experience in managing fixed income securities. - Be highly skilled in securities analysis and valuation. - Be proficient in portfolio optimization techniques. - Have a strong background in financial reporting and tracking. The ultimate goal of this project is to generate detailed, comprehensive reports on the portfolio's performance.
We need to make work an Excel Add-in working in Office 365 or Excel 2016. It works in Older OS & Excel versions but not in newer versions.
I'm seeking a professional to assist with the preparation of documentation related to an increase in child support. The primary focus will be on income verification. Ideal Skills and Experience: - Familiarity with child support processes - Experience with documentation preparation - Ability to conduct financial assessments - Legal knowledge in child support matters is a plus - Skills in creating and organizing income verification documents
I'm in need of a seasoned bookkeeping professional who can assist with my various bookkeeping tasks using Microsoft Excel and the accounting software, Xero. Tasks will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Skills and Experience: - Proficient in Microsoft Excel - Prior experience in bookkeeping and managing accounts - High attention to detail for accurate data entry and bank reconciliation - Familiarity with QuickBooks is a plus My bookkeeping process is standardized, so the main requirement is to assist with the execution of tasks rather than setting up a new system.
I'm in need of a dedicated professional who can conduct thorough online research and compile the gathered information into organized spreadsheets and documents. Ideal skills and experience for the job: - Proficient in online research - Strong skills in Microsoft Excel and Google Sheets - Ability to create clear and comprehensive documents - Experience in market research and competitor analysis - Excellent understanding of customer insights
...are seeking an experienced developer or development team to create a custom Franchise and Affiliate Management System for PraticaTrading. This system will empower franchisees to manage their business networks effectively, while affiliates can control and track their individual activities through a dedicated back-office. Project Requirements: Affiliate System for Franchisees: Allows franchisees to register, manage, and track their affiliates. A dedicated backend panel for franchisees to view detailed reports on affiliate sales, referrals, and earned commissions. Franchisee Control Backend: A control panel for PraticaTrading’s central administration to monitor franchisees, track performance metrics, and manage commissions and financial r...
...looking for an experienced proofreader to ensure the quality of our Vietnamese (VN) translations for our app. This is a long-term project, as we need ongoing maintenance and updates for our app and its content. We seek to establish a long-term collaborative relationship. Key Responsibilities: - Proofread and edit VN translations related to financial content and app UI copy. - Provide clear and timely feedback. - Ensure translations are culturally and contextually appropriate. - Occasionally conduct research and fact-checking to ensure accuracy. Requirements: - Native Vietnamese speaker - Proven experience in proofreading Vietnamese content, preferably in the finance industry and app UI content - Strong command of Vietnamese grammar an...
...team to design and develop a web and mobile platform for bus and car booking. The project includes features for clients, travel agencies, and administrators. Main Objectives: 1. Provide a user-friendly platform for users. 2. Allow travel agencies to manage their fleet and promote their vehicles. 3. Automatically calculate prices based on criteria (distance, vehicle type, duration). Target Audience: - End-users: Tourists, businesses, schools, individuals. - Travel agencies: Owners of buses, minibuses, and cars. Main Features: For clients: - Search based on departure point, destination, and parking duration. - Display available vehicles with prices. - Instant booking with secure online payment. - Notifications via email/SMS to confirm bookings. For agen...
...industry. The ideal candidate will play a pivotal role in expanding our international market presence, identifying growth opportunities, and fostering strong partnerships with key stakeholders across global markets. This role offers a competitive base salary, a fixed commission on each successfully closed deal, comprehensive medical insurance, and allowances, ensuring direct recognition and rewards for contributions to business growth. ***Key Responsibilities*** 1. Identify and pursue new business opportunities in overseas markets to drive revenue growth. 2. Oversee the full import/export lifecycle, ensuring adherence to international trade regulations, customs requirements, and compliance standards. 3. Conduct in-depth market research to...
...seeking an experienced engineer to perform a Finite Element Method (FEM) analysis on a plastic part, specifically a housing made from the material PC2807. This analysis will help determine the stress and deformation of the housing when two screws are tightened to a torque of 2Nm. Key Aspects of the Project: - You'll need to calculate the maximum torque that can be applied by the screws without causing failure or excessive deformation of the housing. - The boundary conditions to consider for the FEM analysis include the handlebar and brake being fixed, while the housing is free to deform. - You will have access to both the elastic modulus and Poisson's ratio as well as the stress-strain curve for the PC2807 material. Ideal Ski...
I run a Financial educational YouTube channel and I'm in need of a creative professional who can help with crafting engaging scripts and designing eye-catching thumbnails. Key Responsibilities: - Develop informal, yet educational scripts for my YouTube videos. - Create visually appealing thumbnails that align with the channel's tone. - Follow the steps and process guideline to achieve the goals Ideal Skills: - Expertise in YouTube scriptwriting with a focus on education. - Graphic design skills, particularly in creating YouTube thumbnails. - Understanding of YouTube's algorithm and viewer engagement strategies. If you don't know any of that, it's fine, because the steps and process is easy to learn. We do everything wit...
I'm in need of a mobile application that operates seamlessly on both Android and iOS platforms. This app will serve as a financial advisor for users, guiding them on how to allocate their investment portfolios, primarily focusing on stock market investments. Key Features: - Portfolio Tracking: The app should provide an interface for users to monitor their investment portfolios. This includes tracking the performance of individual stocks as well as the overall portfolio. - Advice Notifications: Users should receive timely notifications with financial advice. This could pertain to potential investment opportunities, portfolio adjustments, or market alerts. - User Interaction: The app should be designed for users to interact with i...
I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.
...Context: We are looking for Consultants with expertise in SAP BW and SAP Analytics Cloud for planning and forecasting: • You will be supporting development and operations activities on a large, multi-year transformation programme - where the goal is to move the finance organisation into the Digital age • The role is remote (on UK shift hours) and you will join a DevOps squad with team members based in the UK, US and India Job Description: We are looking for candidates who have previous experience in client facing roles at the Big 5 IT consulting companies. As a Consultant – SAC/BW Developer, you will contribute to implementing robust SAP Analytics solutions by leveraging your hands-on skills in SAC and BW. You will play a critic...
I'm looking for a proficient web developer who can create a single-page website for me. This site will be used to manually post Buy/Sell stock signals through an admin panel. Key Features: - A simple, user-friendly interface where I can post stock signals - Integration of various ad formats, with a primary emphasis on rewarded ads Ideal Skills: - Experience with creating custom Websites - Familiarity with integrating ads into websites - Prior experience with financial or stock-related websites is a plus. Please, only bid if you can deliver a high-quality, professional site that meets these specifications.
...media expert to manage my Youtube channel page [@im-aam_official]. Key Responsibilities: - Create and/or manage engaging content primarily focusing on images and videos. - Strategically enhance brand visibility . - Regularly analyze social media metrics and adjust strategies accordingly. - Collaborate with influencers and brand ambassadors or make backlinks to enhance reach and engagement. - Engage with followers through comments, likes, and direct messages to foster community. - Implement effective hashtag strategies to increase visibility and engagement. - Monitor social media trends and integrate them into content and strategies. Ideal Skills and Experience: - Proven track record in social media management, particularly on LinkedIn, Youtube and I...
I need a professional to conduct a comprehensive audit review on regulatory audit firms.
Copywriting, pdf, data entry, excel, word
...skilled web developer to create an informational web application intended for internal team use. The primary function of this platform is to serve as a hub of important information, with a dedicated contact form for team queries and feedback. Key Features: - An intuitive and user-friendly interface that allows easy navigation and information access. - A secure and private environment, with appropriate access controls to protect sensitive information. - A responsive design, ensuring usability across various devices. Define the basic requirements: Basic features: User management: Log in users (admin, employee, etc.). Create a quote(jobe): Enter customer details, products or services, prices, and taxes. Jobs section (airport/ land /sea) Convert to invoi...
I'm conducting academic research and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0.05 is ...help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0.05 is Finite Population Adjusted Sample Size needed? I need an excel with the formula and the steps broken down t...
...I am reaching out to outline a comprehensive plan for creating Excel sheets with detailed product information from the following link: Grab Mart Merchant Link. ( ) Project Overview The goal is to compile full product information, including price, product photos (edited with a white background), product weight, and product category. Each category will have its own separate Excel sheet and corresponding Google Drive folder for storing photos. The product name on the photo and in the Excel sheet must match. Additionally, we will need to find barcodes for all products, as none are provided in the link. The total number of products is approximately 2,600. Steps to Complete the Project
I'm seeking professional training and support with MYOB for my long daycare center. The ideal candidate will provide one-on-one training sessions focused on key areas including payroll management, expense tracking, and financial reporting. Ultimately, I want to feel confident navigating MYOB and utilizing it to its full potential in managing my daycare's finances.
I need a detailed guidance, how to create the call of the 'Web Scraper' Agent from Apify with domains coming via make (one by one or bage) .
I need a spreadsheet expert to help me streamline my expense tracking tables with automatic calculations. My spreadsheet contains financial data and is primarily used for tracking expenses. The goal is to make the tracking process easier and more efficient. Ideal Skills: - Proficient in Excel or Google Sheets - Experience with financial spreadsheets - Knowledge of creating automatic calculations - Attention to detail for tracking accuracy - Ability to optimize and improve existing tables Please provide examples of similar projects you have completed in the past.
...looking for a talented and experienced freelancer to create a polished, modern, and professional resume for a recent graduate in Business Administration. The resume should effectively showcase his education, internship experience, skills, and interests to help him stand out in the competitive job market. Scope of Work: Design a visually appealing, ATS-compliant resume that highlights key strengths. Include sections for education, work experience, skills, certifications, hobbies, and career goals. Use clear and professional formatting suitable for entry-level positions in marketing or project management. Provide both one-page and two-page versions of the resume in PDF and editable formats. Details to Include: Education: From high school...
I'm looking for a talented graphic designer who can create a modern and sleek flyer for The Word Church. The flyer is to be sized 1024X768 and should prominently feature our 2025 theme: "Upgrade, Elevate, & Excel" (Ephesians 3:20). Key elements to be included: - The text: "The Word Church", "2025: Upgrade, Elevate & Excel (Ephesians 3:20)", "Tony Ray Smith, Senior Pastor", "". - A focus on the theme of 2025: Upgrade, Elevate, & Excel. - Our church logo. - A photo of our pastor. Example IMG_9673 ' Design specifications: - A modern and sleek style. - A dominant blue and silver color scheme.
I'm looking for a comprehensive financial model template for analyzing potential multifamily investment properties. The model should be suitable for use with an LLC and accommodate optionality for multiple partners, as I plan to go in on properties with several investors. Key Requirements: - Essential forecasting metrics: Include Cash Flow Analysis, Net Operating Income (NOI), Internal Rate of Return (IRR), 3-statements, return metrics, and a structure that can handle distributions to multiple equity investors. (my experience is fairly limited here, so I may want something in here to help better analyze deals that I'm not currently aware of and could use someone's expertise.) - Financial Statements: Income Statement, Balance...
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its ...
I'm in need of a professional who can assist me with entering financial records into spreadsheets and making cold calls. Data Entry: - You'll be entering financial records into spreadsheets. - I have a general idea of how the spreadsheets should look, but I will need your input and expertise to create a clear and efficient format. Cold Calling: - You'll also be making cold calls on my behalf. - Excellent communication skills and a persuasive demeanor are essential. Ideal Skills: - Proficiency in data entry and spreadsheet software (preferably Excel). - Previous experience with financial data is a plus. - Strong communication skills for cold calling. - Ability to understand and contribute to spreadsh...
