Boost Your Grades With Us Today!

support@writernursing.com      Contact us +1 (332)-240-3699

Browse Over 10 Million Questions

Let Our Professionals Assist You With Research and Writing. 

student_PNG181.png

Determine the yearly values and enter them into your budget.

Assignment Instructions

For this exercise we are going to create a simple budget, and track our budget compliance over the course of a 12 month period.  Although it is possible (and common) to track budget compliance on a month to month basis, to keep things simple for this exercise we are going to only examine the year end result.

Start by creating a budget in Excel in the following format.

Spreadsheet image

For the starting budget $ amounts you use the following logic.  Determine the yearly values and enter them into your budget.  Don’t forget to add the totals, and to determine the amount you are short/extra.

Assignment Instructions

For this exercise we are going to create a simple budget, and track our budget compliance over the course of a 12 month period.  Although it is possible (and common) to track budget compliance on a month to month basis, to keep things simple for this exercise we are going to only examine the year end result.

Start by creating a budget in Excel in the following format.

Spreadsheet image

For the starting budget $ amounts you use the following logic.  Determine the yearly values and enter them into your budget.  Don’t forget to add the totals, and to determine the amount you are short/extra.

Salary = $4,000 a month

Rent = $1200 a month

Car payment = $650 a month

Phone = $95 a month

Health Insurance = $250 a month

Food = $500 a month

We are now going to add the following data for the monthly amounts in out spreadsheet

Salary:  Your starting salary for the year is $4,000 a month.  In June you get a 3% pay increase.

Additionally you get a one-time bonus payout of $500 in October.

Rent:  Your monthly rent per your lease is $1,200 a month, with a 5% increase in November.

Car:  Your car is under lease at a rate of $650 a month.

Phone:  Your month rate for your phone is $95 a month, but you incurred overage charges of $25 each in the months of April, August, and December.

Health Insurance:  Your monthly installments for health insurance are $250 a month.

Food: Food expense tends to be more varied than the other expenses be captured.  Use the follow table to enter your food expenses.

food expense

Other:  In the month of March you have a car repair bill of $750 and in August you took a $125 flight to visit your parents.

  Don’t forget to add the totals, and to determine the amount you are short/extra.

Salary = $4,000 a month

Rent = $1200 a month

Car payment = $650 a month

Phone = $95 a month

Health Insurance = $250 a month

Food = $500 a month

We are now going to add the following data for the monthly amounts in out spreadsheet

Salary:  Your starting salary for the year is $4,000 a month.  In June you get a 3% pay increase.

Additionally you get a one-time bonus payout of $500 in October.

Rent:  Your monthly rent per your lease is $1,200 a month, with a 5% increase in November.

Car:  Your car is under lease at a rate of $650 a month.

Phone:  Your month rate for your phone is $95 a month, but you incurred overage charges of $25 each in the months of April, August, and December.

Health Insurance:  Your monthly installments for health insurance are $250 a month.

Food: Food expense tends to be more varied than the other expenses be captured.  Use the follow table to enter your food expenses.

food expense

Other:  In the month of March you have a car repair bill of $750 and in August you took a $125 flight to visit your parents.

 

Submit Your Assignment and get professional help from our qualified experts!


Determine the yearly values and enter them into your budget. was first posted on July 16, 2019 at 12:32 pm.
©2019 "Submit Your Assignment". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at perfectpapers2015@gmail.com

Order a similar paper and get 15% discount on your first order with us

Dr. Thea Watson
Dr. Thea Watson
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Always delivers in time.
John Doe
Designer
Dr. Thea Watson
Dr. Thea Watson
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Always delivers in time.
John Doe
Designer
Dr. Thea Watson
Dr. Thea Watson
98% Success Rate
Read More
"Hi, count on me to deliver quality nursing papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Always delivers in time.
John Doe
Designer
Dr. Thea Watson
Dr. Thea Watson
99% Success Rate
Read More
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"
Always delivers in time.
John Doe
Designer

How Our Essay Writing Service Works

Tell Us Your Requirements

Fill out order details and instructions, then upload any files or additional materials if needed. Then, confirm your order by clicking “Place an Order.”

Make your payment

Your payment is processed by a secure system. We accept Mastercard, Visa, Amex, and Discover. We don’t share any informati.on with third parties

The Writing Process

You can communicate with your writer. Clarify or track order with our customer support team. Upload all the necessary files for the writer to use.

Download your paper

Check your paper on your client profile. If it meets your requirements, approve and download. If any changes are needed, request a revision to be done.

Recent Questions

Stay In Touch!

Leave your email and get discount promo codes and the best essay samples from our writers!
Open chat