Excel - Calculation spreadsheet (EBITDA / DEBT SERVICE COVER RATIO / LOAN REPAYMENTS)

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

I need to create one spreadsheet where i can work out the EBITDA (Earnings before Interest Taxes Depreciation and amortisation). Debt Service Cover Ratio and also Loan Repayment Calculator.

The spreadsheet needs to be in three seperate tables within the one spreadsheet.

Once the EBITA and loan repayments are obtained I need to work out Debt Service Cover Ration (DSCR).

I need to be able to figure out interest repayments repayments based on years of loan and loan%

This is a link to what i need as part of my own spreadsheet.

[login to view URL]

This is a link to work out the EBITDA

[login to view URL]

With the loan repayments, If it's possible to input balloon payment options that would be great.

Excel Accounting Finance

Project ID: #25441857

About the project

20 proposals Remote project Active 3 years ago

Awarded to:

HarryBvdS

Hi, I am completely new to Freelancer. However I have a lot of experience with Excel, having created from scratch Management Accounts for companies for review by company shareholders on weekly, and monthly periods. I More

$20 AUD in 7 days
(6 Reviews)
2.9

20 freelancers are bidding on average $22 for this job

kpnsureshbabu

Hi, Yes we can input baloon payment options too, I am expert in MS-Excel. I am ready to do this. I am ready to start immediately. Regards, Sure

$10 AUD in 3 days
(5 Reviews)
4.6
Muhammad6979

Hello Dear Sir/Madam I am Chartered Accountant(ACCA) and expert in QB, XERO and EXCEL. You can see my profile I do have the relevant skills to do the assigned job within the time period mutually agreed upon. Thanx & More

$20 AUD in 1 day
(22 Reviews)
4.3
Pradip0186

I have completed my Chartered Accountant (C.A) and Bachler of Business Administration (BBA) proficiency degree and engaging in the field of Accountancy, Taxation and Bookkeeping and working since last 6+ Year. Since in More

$10 AUD in 1 day
(1 Review)
1.7
dilhanijayarath4

Hi, I am Dilhani. I am currently following a MBA degree and I have a bit of understanding in Accounting. I think I can do your work with that. Please drop me a message. Thank You!

$30 AUD in 7 days
(5 Reviews)
1.8
koustavacharya20

Hello. Hope All is Well. I am Koustav Acharya. I assure you the following: ✅Skilled in EXCEL, WORD, Data Entry ✅I am Bachelors in Commerce. ✅100% Accuracy ✅4x Faster Typing Speed ✅3 Years Experience ✅Finishes Before- More

$30 AUD in 2 days
(0 Reviews)
0.0
Jasidew2008

Wow, seems like what I enjoy to do! I am an ACCA affiliate and have work on whatever you have asked for. I made few model on spreadsheet regarding EBITDA and Debt Service Cover Ratio from company Financial Report. Anyw More

$20 AUD in 1 day
(0 Reviews)
0.0
snilkamal94

Please hire me, I will definitely complete the job without any complaints

$20 AUD in 1 day
(0 Reviews)
0.0
arshadali32

Professional degree with professional experience will allow me to work with more effectively and efficiently

$25 AUD in 1 day
(0 Reviews)
0.0
Anurag097

Hi I am finance professional and I have vast experience in creating models for lean processing. I understand your requirement and believe to provide you best solution.

$10 AUD in 7 days
(0 Reviews)
0.0
Hiranmaytripathi

i have completed a specialised course in excel. which enhances my skills and will be able to complete work before time.

$23 AUD in 5 days
(0 Reviews)
0.0
kareemullap

Qualified Icwai and holding Mebership with demonstrate experiance of 7 yrs in Financial analyst . Expert knowledge in -Planning, analsying, preparing of Profit & loss account & Balence sheet . -Inventory control. -Pr More

$15 AUD in 5 days
(0 Reviews)
0.0
jmatulis92

Dear project lead, I have an MBA in finance from USA and I'm currently working as a financial and market analyst. I am also working towards a FIMVA certification. I can collect, sort, model and analyze information in More

$20 AUD in 7 days
(0 Reviews)
0.0
sena2148

I am an accountant working at a bank. Though I do not have much experience in the Freelancer platform, I have fulltime work experience over 10 years. I am interested in your project & I am glad to help you. I am flexi More

$20 AUD in 7 days
(0 Reviews)
0.0
RAACOUNTER

Dear Sir, I do have required knowledge which was gathered in my accountancy degree and more than 10 years industry experience to full fill your requirement. Balloon payment option also can be apply as per your expe More

$20 AUD in 5 days
(0 Reviews)
0.0
agrawalrupali9

I am qualified Chartered Accountant a self-motivated person who is willing to go above and beyond on any project, and to learn valuable skills on my own time. I have good knowledge of accounting and finance and well ve More

$20 AUD in 7 days
(0 Reviews)
0.0