{"id":862,"date":"2015-08-11T01:54:46","date_gmt":"2015-08-11T01:54:46","guid":{"rendered":"https:\/\/courses.candelalearning.com\/computerapps\/?post_type=chapter&#038;p=862"},"modified":"2015-09-14T04:34:07","modified_gmt":"2015-09-14T04:34:07","slug":"assignment-four-personal-budgets-in-excel","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/chapter\/assignment-four-personal-budgets-in-excel\/","title":{"raw":"Assignment: Four Personal Budgets in Excel","rendered":"Assignment: Four Personal Budgets in Excel"},"content":{"raw":"For this activity, you will complete four budgets - one Business budget, one Forecasts (projects) budget, one Home Budget, and one Customized Personal Budget.\r\n\r\nDirections:\r\n\r\n1. Review the module content related to Microsoft Excel 2010.\r\n\r\n2. In Microsoft Excel, click on File, New, and Budgets.\r\n\r\n3. Select one template out of each of the following categories:\r\n<ul>\r\n<ul>\r\n\t<li>1 template from Business Budgets<\/li>\r\n\t<li>1 template from Forecasts (projects)<\/li>\r\n\t<li>1 template from Home Budgets<\/li>\r\n<\/ul>\r\n<\/ul>\r\n4. Plan a budget from each of the categories for:\r\n<ul>\r\n<ul>\r\n\t<li>your future business using the Business Budget template<\/li>\r\n\t<li>your future project(s) using the Forecasts template<\/li>\r\n\t<li>your future home expenses using the Home Budget template<\/li>\r\n<\/ul>\r\n<\/ul>\r\n5. Next, complete a customized personal budget based on your future income.\r\n<ul>\r\n\t<li>To assist you with this, visit\u00a0<a class=\"external\" href=\"http:\/\/www.salary.com\/\" target=\"_blank\">http:\/\/www.salary.com<span class=\"screenreader-only\">\u00a0(Links to an external site.)<\/span><\/a>\u00a0and research your future salary based on your major and the area that you are planning to live in.<\/li>\r\n\t<li>Research the area where you would like to live after graduating from Wiley College.<\/li>\r\n\t<li>Be sure to consider the cost of housing, food, etc. in the area using, for example, a Google search related to the budget item and the area.<\/li>\r\n<\/ul>\r\n6. \u00a0Save all four budgets:\r\n<ul>\r\n\t<li>Business Budget using Excel Templates<\/li>\r\n\t<li>Forecasts (projects) Budget using Excel Templates<\/li>\r\n\t<li>Home Budget using Excel Templates<\/li>\r\n\t<li>Customized Personal Budget<\/li>\r\n<\/ul>\r\n7.\u00a0Upload your budgets to the submission.","rendered":"<p>For this activity, you will complete four budgets &#8211; one Business budget, one Forecasts (projects) budget, one Home Budget, and one Customized Personal Budget.<\/p>\n<p>Directions:<\/p>\n<p>1. Review the module content related to Microsoft Excel 2010.<\/p>\n<p>2. In Microsoft Excel, click on File, New, and Budgets.<\/p>\n<p>3. Select one template out of each of the following categories:<\/p>\n<ul>\n<li>1 template from Business Budgets<\/li>\n<li>1 template from Forecasts (projects)<\/li>\n<li>1 template from Home Budgets<\/li>\n<\/ul>\n<p>4. Plan a budget from each of the categories for:<\/p>\n<ul>\n<li>your future business using the Business Budget template<\/li>\n<li>your future project(s) using the Forecasts template<\/li>\n<li>your future home expenses using the Home Budget template<\/li>\n<\/ul>\n<p>5. Next, complete a customized personal budget based on your future income.<\/p>\n<ul>\n<li>To assist you with this, visit\u00a0<a class=\"external\" href=\"http:\/\/www.salary.com\/\" target=\"_blank\">http:\/\/www.salary.com<span class=\"screenreader-only\">\u00a0(Links to an external site.)<\/span><\/a>\u00a0and research your future salary based on your major and the area that you are planning to live in.<\/li>\n<li>Research the area where you would like to live after graduating from Wiley College.<\/li>\n<li>Be sure to consider the cost of housing, food, etc. in the area using, for example, a Google search related to the budget item and the area.<\/li>\n<\/ul>\n<p>6. \u00a0Save all four budgets:<\/p>\n<ul>\n<li>Business Budget using Excel Templates<\/li>\n<li>Forecasts (projects) Budget using Excel Templates<\/li>\n<li>Home Budget using Excel Templates<\/li>\n<li>Customized Personal Budget<\/li>\n<\/ul>\n<p>7.\u00a0Upload your budgets to the submission.<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-862\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Shared previously<\/div><ul class=\"citation-list\"><li>Budget Assignment. <strong>Authored by<\/strong>: Veronica McEachin. <strong>Provided by<\/strong>: Wiley College . <strong>Project<\/strong>: Kaleidoscope Open Course Initiative. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":74,"menu_order":25,"template":"","meta":{"_candela_citation":"[{\"type\":\"cc\",\"description\":\"Budget Assignment\",\"author\":\"Veronica McEachin\",\"organization\":\"Wiley College \",\"url\":\"\",\"project\":\"Kaleidoscope Open Course Initiative\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-862","chapter","type-chapter","status-publish","hentry"],"part":567,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapters\/862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/wp\/v2\/users\/74"}],"version-history":[{"count":1,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapters\/862\/revisions"}],"predecessor-version":[{"id":864,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapters\/862\/revisions\/864"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/parts\/567"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapters\/862\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/wp\/v2\/media?parent=862"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/pressbooks\/v2\/chapter-type?post=862"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/wp\/v2\/contributor?post=862"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/sanjacinto-computerapps\/wp-json\/wp\/v2\/license?post=862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}